Data labels on a stacked chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a simple stacked bar chart, but i would like to display the total for
the two items stacked for each bar. For example, hearth is $100 and is
stacked over Indoor with a value of $200. I can display the data label of
each, but would like to display $300 instead.
 
whouser,

There are several ways that you can do this. One way is to create a
secondary reference that consists of the data labels. For example, assume
you have this data for your stacked bar chart.

Series1 Series2
a 100 200
b 150 250
c 125 100

Set up an additional reference that adds the data for the two series together.

Series1 Series2 Labels
a 100 200 300
b 150 250 400
c 125 100 225

Then use a data labeling tool or macro to connect a reference from Series2
to Labels. You can find a list of where to get those tools here:

http://www.pdbook.com/index.php/excel/adding_independent_data_labels/
 
Back
Top