stacked column chart

  • Thread starter Thread starter Kelly McFaul
  • Start date Start date
K

Kelly McFaul

Hi,
I have a sheet that I need to make a stacked column chart from. The data
looks like this
A B C D
1:15 51 34 85 (with column d being the total of b + c)
1:30 49 13 62
1:45 57 12 69
2:00 54 9 63

Column A is the X axis. I have no trouble making the chart, but I would like
the total (column D) to show up as the data labels. When I include column D
in the range, it just shows up as 3 different sets of values, making the
total appear to be doubled. I hope that makes sense--I think I had a harder
time asking the question, than I did making the chart!! :)
Thanks, and I'm using Excel 2000.
 
After you create the stacked column chart, right-click on the Total
series. Choose Chart Type, and change the series to a Line chart. Format
the Line chart to have None as the line, and None as the Marker. Add
value labels to the line series.
 
Back
Top