View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
metc721 metc721 is offline
external usenet poster
 
Posts: 2
Default whole Numbers entered; percentages displayed.

I want to create a chart from data similar to the following example:
x1 x2 x3
total 1000 500 750
a 250 100 375
b 300 200 100
c 200 50 180

On the chart, I want the Y-axis to show the amount but the data label inside
the chart to show the percentage each number is of the total (the top number)
in its column.

Possible? Difficult?

Thanks to anyone who can/will help!