Data Label formats for Excel Bar graphs

[Optimus29]

Hello Friends,

I am facing issue with Excel data labels.

I have a Bar graph generated in Excel presenting some percentage values.

I want to introduce a new data label. If a data in a perticular cell is anything other than a percentage value (For Ex: NA) It should display the data label in a graph as "Not Applicable". for rest of the valid percentage value it should display correspodning value.

Is there anyway to accomplish this using data label formats.

Thanks in advance!

 

[RoryA]

Hi and welcome to the forum.

Unfortunately I don't think any number format will work for this, since error values ignore number formatting. If you convert the errors to text, they will plot as 0 and you could apply a custom format to 0 values, but obviously that won't work if 0 is actually a valid data value for you.

 

[Andrew Poulsom]

Welcome to MrExcel.

Here's an Add-In you can try:

http://www.appspro.com/Utilities/ChartLabeler.htm

 

[Optimus29]

Welcome to MrExcel.

Here's an Add-In you can try:

http://www.appspro.com/Utilities/ChartLabeler.htm

Thanks Andrew I will try with this add-in at home however I can't get this Add-in for my office PC due to some security policies.

Still thank you very much for your help!

 

[Optimus29]

Hi and welcome to the forum.

Unfortunately I don't think any number format will work for this, since error values ignore number formatting. If you convert the errors to text, they will plot as 0 and you could apply a custom format to 0 values, but obviously that won't work if 0 is actually a valid data value for you.

Hi Rorya,

Thanks for the quick reply.

Can you please elaborate on applying custom format for 0s?

I guess I will find some work around with that

 

[RoryA]

You can apply a custom number format of:
0%;-0%;"No data"

for example.

 

[Optimus29]

You can apply a custom number format of:
0%;-0%;"No data"

for example.

Thank you so much Rorya!