How to Show Percentage in Bar Label

[Sanjibghosh]

I want to show Values & percentage in bar label. But i can show only Value in the label. Please help me how to show the percentage also in bar label.

[AliGW]

I am using Excel 2016.

1. Right-click the leftmost blue bar in the table and select Format Data Labels ...
2. Tick the box near the top that says Value From Cells, then select C2 to C6 as the range.
3. Change the separator from a comma to a new line in the drop-down box below.

Repeat for the other bars.

All done!

[Sanjibghosh]

Hi AliGW,

Thank you for your quick response,

As per your instruction i am doing the same. But it's not showing. Can do it in the excel file for me?

[AliGW]

See the attached. I have done it just for the leftmost blue bar. Replicate what I have done on the others.

[Sanjibghosh]

Thank you So much

[AliGW]

You're welcome!

[Sanjibghosh]

I need one more help. I don't want to show 0.00% value from labels