Replace Chart Values with Second Set of Values
 

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.

Replace Chart Values with Second Set of Values
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Brian Erhard" wrote in message
ups.com...
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.