How to show numbers on y-axis and percentages on data labels?

  • Thread starter Thread starter Megan
  • Start date Start date
M

Megan

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?
 
(replying to myself?!)

never mind - i found everything i need in the topic "Excel bar charts with
percentages"

thx
 
Never mind! I found everything I needed from the post titled "Excel bar
charts with percentages"

Thx
 
Back
Top