Replace Chart Values with Second Set of Values

  • Thread starter Thread starter Brian Erhard
  • Start date Start date
B

Brian Erhard

Hello,

I would like to create a "100% Stacked Column" Chart using the over
simplified example below:

% in 2002 $ in 2002 % in 2003 $ in 2004
x 10% $200 12% $210
y 20% $400 24% $450
z 70% $600 64% $1,000

I would like the bars of the chart to be divided based on the
percentages (% in 2002 and % in 2003), but I instead of the values of
the percentages appearing I would like the dollar amounts to appear.

Any suggestions?

Thanks.
 
Make the chart based on the percentages. Then use one of these utilities
(both free and very well done) to apply labels using the dollar values in
the worksheet:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

- Jon
 
Back
Top