Is there a way to suppress zeros on a chart?

[BittenApple]

Hello team,

I have a chart and this chart is dynamic and it is made of named ranges instead of using ranges themselves.
I wonder if I can suppress zeros.

Regards,

[HansV]

You can specify how a chart should handle hidden and empty cells:

S0478.png

But you can't suppress zero values. Will the zeros be at the end of the range, or will they be interspersed with non-zero values?

[BittenApple]

Hello Hans,
They are zero values of in chart series at the bottoms of chart.
Where is this dialog box? Is it from 365?

Regards,

[HansV]

That dialog box can be activated in all recent versions of Excel.
- Click anywhere in a chart.
- On the Design tab of the ribbon, under Chart Tools, in the Data group, click Select Data.

S0480.png

- Click the Hidden and Empty Cells button in the lower left corner of the Select Data Source dialog.

S0481.png

[BittenApple]

Thanks,
It did take care of my issue.
Regards,

[BittenApple]

Hello Hans,
It still shows 0% when the value of series 0% in the data.
Regards,

[HansV]

If you want to suppress zero values, you'll either have to clear the cells with zeros, or hide their rows.

[BittenApple]

Ok, thanks for explanation.