Displaying Added Values in Stacked-Bar Graph

J

J. Joshi

Hello all,

I have a "Stacked-Column" Bar Graph that looks at 2 data-
sets in 2 different columns. I can see the values in each
bar. But now I want to add both the data-set values and
show the addition on top of the bar. How do I do that? I
cannot seem to figure a way out or believe that microsoft
allows me to do an addition and place that value on top of
each bar.

Thanks.

Joshi
 
F

Frank Kabel

Hi
try the following:
-.create a third column with the sum of these two columns
- add this column to your chart as third stacked element
- format the color as 'white/transparent'
- add the value as label (and format to show at the bottom of this
series)
- probably change the Axis scale
 
Top