[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 256
  • Last Modified:

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.
0
Mr_Shaw
Asked:
Mr_Shaw
3 Solutions
 
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
 
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:
Thanks
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now