View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Brian Erhard Brian Erhard is offline
external usenet poster
 
Posts: 3
Default 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.