Replace Chart Values with Second Set of Values

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replace Chart Values with Second Set of Values 1
The lowest of all? 6
A list and chart from two pivot tables 0
Finding the weighted average of text that have been given values 1
Display percent and value on stacked column chart 0
stacked column chart 4
Setting series values on Excel Chart 0
Percentages AND Value lables on Stacked Columns 1

Top