| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to show numbers on y-axis and percentages on data labels?
I have a two data series to place on a chart (chart type = stacked column).
I would like to have the y-axis show the numbers and the data labels show the percentage of total for that particular data point. For instance: x-axis Pass Fail PDL FDL point1 7 5 58% 42% point2 1 6 14% 86% point3 8 8 50% 50% point4 15 4 79% 21% The y-axis would show values 1-15 (say) and the height of series "pass", point1 would be 7. The data label for this point on this series would be "58%". Any suggestions on how to do this without manually editing each data label? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to show numbers on y-axis and percentages on data labels?
(replying to myself?!)
never mind - i found everything i need in the topic "Excel bar charts with percentages" thx |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
worked it out!
Never mind! I found everything I needed from the post titled "Excel bar charts with percentages" Thx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Don't want to show X axis labels. | Excel Discussion (Misc queries) | |||
| show a column of numbers also as percentages | Excel Worksheet Functions | |||
| Data Labels with Percentages | Charts and Charting in Excel | |||
| How do I add percentages to data labels? | Charts and Charting in Excel | |||
| How do I set "y" axis to numbers and labels to percentages on my . | Charts and Charting in Excel | |||
Linear Mode
