Chart-plotting %age but data label displaying absolute number

[22strider]

Hello Friends,

Is there a way of displaying absolute numbers (for example 50/100) as data labels on the chart plotting %age.

I have a line chart plotting %age of some data. I would like to display absolute numbers for qualifying %age chart.
For example the date point on the chart is 50% I would like to display (like data labels) 12/24.

Rationale for displaying absolute number is to qualify data displayed by two different series. For example one supplier has 1 shipment delayed out of total 2 and another has 50 out of 100; displaying absolute numbers adds to the information.

Please let me know if there is way of displaying absolute numbers while plotting %age charts.

Regards,
Rajesh

 

[pbornemeier]

Format the values in question as "Fractions" and turn on data labels the fractions will appear next to each point.