100% Stacked Bar chart, two bars, want percent as well as real value

  • Thread starter Thread starter mr.sandog
  • Start date Start date
M

mr.sandog

I am attempting to chart the following:
Series 1 - Values over the prior 30 days
Series 2 - Values over the prior 12 months

I would like to show both data series as 100% bar charts, so users of
the information can compare percentage of the last 30 days with
percentage of the same piece of data over the last 12 months.

So, for example the two data series might look like this:

Series 1
20
25
45
65

Series 2
211
324
403
822

I want to display both the actual value, and the percentage of the
total, for each series, in the labels. For some reason, showing
percentage is not an option. Why is this?
 
Although showing the percentage is not an option, you can easily do so by
creating two "dummy" series with data labels showing those percentages. To
do so, create a series 3 and series 4 consisting of all zeros. Then create
two seperate columns called "Series 3 Labels" and "Series 4 Labels".
Calculate the percentages for series 3 and series 4 and add them to the
"Series 3 Labels" and "Series 4 Labels" columns. Then use a tool such as
John Walkenbach's Chart Tools to add those data labels to series 3 and 4.
You can download John's tool at:

http://www.j-walk.com/ss/excel/files/charttools.htm
 
Back
Top