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

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?
 
M

Megan

(replying to myself?!)

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

thx
 
M

Megan

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

Thx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top