stacked column chart

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.

Kelly McFaul wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html