Hiding items in horizontal axis

Is it possible to hide an item in axis if there is no data.

For example, my horizontal axis shows Months. There was no data for March, so can I hide March. The axis lable range is read from column A.
Mr_ShawAsked:
Who is Participating?
 
Rory ArchibaldCommented:
If you just want to hide the blank ones at the end, you can also do that by using dynamic named ranges for the chart series.
0
 
Mr_ShawAuthor Commented:
here is a screen shot.

Since there is no data yet from Sep,Oct,Nov and Dec I want to hide the items on the horizontal axis.
Excel.png
0
 
andrewssd3Commented:
The category values don't look as though they're being treated as dates, just as ordinary text categories.  You can stop the empty ones appearing on the chart just by hiding the rows, if you're happy to have them hidden.
0
 
Mr_ShawAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.