Hello all,
I have a chart whose x axis are months. Sometime for some of the months we don't have any values and zeros are being shown on x axis. How to hide these zeros?
Regards,
Bittenapple
How to hide zeros on the X axis?
-
BittenApple
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
-
HansV
- Administrator
- Posts: 78402
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: How to hide zeros on the X axis?
Click anywhere in the chart.
On the Chart Design tab of the ribbon, click Select Data.
Click the button 'Hidden and Empty Cells'.
There are radio buttons for "Show empty cells as'.
Select Gaps, then click OK.
On the Chart Design tab of the ribbon, click Select Data.
Click the button 'Hidden and Empty Cells'.
There are radio buttons for "Show empty cells as'.
Select Gaps, then click OK.
Best wishes,
Hans
Hans
-
BittenApple
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: How to hide zeros on the X axis?
Hello Hans,
I did this solution before and it resolve my issue. I will try it again.
Thanks for the response.
Bittenapple
I did this solution before and it resolve my issue. I will try it again.
Thanks for the response.
Bittenapple
-
BittenApple
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: How to hide zeros on the X axis?
Hello Hans,
Thanks for your response. I will get back to you on this one, still working on it.
Regards,
Bito
Thanks for your response. I will get back to you on this one, still working on it.
Regards,
Bito