Excel chart to display both values & percentage

Hi,

Is it possible to have more than one label options for a single data row in order to display both values and percentage.

Using secondary data (secondary axis) is not a good solution as addtional chart will appear in the graph.



regards,
Farid

Hi,

How to display both values & percentage for a single data row?

Much appreciate if anyone could hep me.


Regards,
Farid.

With Chart Type set to Pie, yes you can.
Change your chart type to Pie, and right click on the values, pick Format Data Labels and tick Percentage.

sorry, i want bar chart instead of pie chart

Hi,

Thanks for sharing.

will try 1st. if ok will remark solved