Hide data labels with zero values WITHOUT changing number format

[raheem]

Hi,
How to hide data labels with zero value? I did a bit search but all solutions suggested are by changing number format. As I already have a defined number format in the chart, changing format is not an option. Also, VBA is not an option.

 

[Michael M]

As I already have a defined number format in the chart, changing format is not an option. Also, VBA is not an option.

In that case ....I don't believe you can !

 

[raheem]

In that case ....I don't believe you can !

Is there any VBA option or the ONLY way is to change number format?

 

[Michael M]

Is there any VBA option or the ONLY way is to change number format?

I thought you said VBA wasn't an option !!!
Have you thought about using IF statements and NA() in your data table to eliminate series so they don't get plotted on the graph?

 

[raheem]

I thought you said VBA wasn't an option !!!
Have you thought about using IF statements and NA() in your data table to eliminate series so they don't get plotted on the graph?

yes first I do said vba is not option but can be tried. Unfortunately data table has to be in Accounting format. It is just that zeros on charts look ugly. Anyway, will try manually deletingzero labels.

 

[Dave Paradi]

You can convert the zero values to #N/A values as shown in this video:

. That way the data labels are not shown.

 

[RoryA]

Why can't you change the number format of the data labels? It won't affect the data table.

 

[raheem]

Why can't you change the number format of the data labels? It won't affect the data table.

Because the non zero values must follow a specific format.

 

[raheem]

You can convert the zero values to #N/A values as shown in this video:

. That way the data labels are not shown.

Thanks. This helps at least

 

[RoryA]

Because the non zero values must follow a specific format.

I don’t see your point. You can format positive and negative values as you need.