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.
 
I saw this question a couple days ago on another forum.

Use one of these free and well-made Excel add-ins to apply labels from the
dollar ranges to the series made with the percentage ranges:

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

- Jon
 
Back
Top