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,
Is there a way to suppress zeros on a chart?
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
-
- Administrator
- Posts: 78524
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Is there a way to suppress zeros on a chart?
You can specify how a chart should handle hidden and empty cells:
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?
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?
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Is there a way to suppress zeros on a chart?
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,
They are zero values of in chart series at the bottoms of chart.
Where is this dialog box? Is it from 365?
Regards,
-
- Administrator
- Posts: 78524
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Is there a way to suppress zeros on a chart?
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.
- Click the Hidden and Empty Cells button in the lower left corner of the Select Data Source dialog.
- Click anywhere in a chart.
- On the Design tab of the ribbon, under Chart Tools, in the Data group, click Select Data.
- Click the Hidden and Empty Cells button in the lower left corner of the Select Data Source dialog.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Is there a way to suppress zeros on a chart?
Thanks,
It did take care of my issue.
Regards,
It did take care of my issue.
Regards,
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Is there a way to suppress zeros on a chart?
Hello Hans,
It still shows 0% when the value of series 0% in the data.
Regards,
It still shows 0% when the value of series 0% in the data.
Regards,
-
- Administrator
- Posts: 78524
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Is there a way to suppress zeros on a chart?
If you want to suppress zero values, you'll either have to clear the cells with zeros, or hide their rows.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Is there a way to suppress zeros on a chart?
Ok, thanks for explanation.