total value of stacked charts
 

I am working with stacked bar charts. I would like to be able to show the
total value of each bar. How do you do that?

Example: Sales of fruit by month. January sales: $30 apples, $20 pears,
$50 oranges.
I want a label above the January bar that says 100.

Hi,

This should help,
http://www.andypope.info/charts/StackColTotal.htm

Cheers
Andy

OkieViking wrote:
I am working with stacked bar charts. I would like to be able to show the
total value of each bar. How do you do that?

Example: Sales of fruit by month. January sales: $30 apples, $20 pears,
$50 oranges.
I want a label above the January bar that says 100.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info