Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In spread sheet the numbers entered as whole numbers become decim | Excel Worksheet Functions | |||
Frogs in the pond - percentages not numbers | Charts and Charting in Excel | |||
How to calculate pass/fail percentages entered on a spreadsheet? | New Users to Excel | |||
formatted numbers displayed as ##### | New Users to Excel | |||
Change percentages to numbers | Excel Worksheet Functions |