Hiding items in horizontal axis

Posted on 2011-10-05
Last Modified: 2012-05-12
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.
Question by:Mr_Shaw
    LVL 12

    Assisted Solution


    Author Comment

    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.
    LVL 17

    Assisted Solution

    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.
    LVL 85

    Accepted Solution

    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.

    Author Closing Comment


    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
    Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now