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!

whole Numbers entered; percentages displayed.
 

Make some columns with calculated percents then use a chart label addin.
Rob Bovey's Chart Labeller, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com
Tushar's Hover Chart Label utility:
http://tushar-mehta.com/excel/softwa...abel/index.htm
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email


"metc721" wrote in message
...
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!

whole Numbers entered; percentages displayed.
 

Just noticed that Andy answered you yesterday! Why the same question?
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"metc721" wrote in message
...
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!