Replace Chart Values with Second Set of Values

[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.

 

[Jon Peltier]

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