• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Problem removing unwanted months from X-axis in an Excel clustered column graph

A

Avi Usgaonkar

New Member
I have a need to present billed and collected amounts by month. There was nothing billed or collected in some of the months and I would like to remove those "empty" months from my graphical plot. The way I have known to accomplish this in previous versions of Excel is to select the horizontal (months) axis -> Format Axis -> Axis Options -> Axis Type -> Select "Text axis". I am running Excel 365 and the above method is not working for me. Any ideas what I may be missing? Sample file uploaded.
 

Attachments

  • Do Not Display Months with No Data.xlsx
    14.6 KB · Views: 3
The way your data is organized you can do it by hiding columns with no data.

Make sure "Show data in hidden rows and columns" option is not selected in "Hidden and Empty Cell Settings". Which is found in "Select Data Source" window.
upload_2016-7-14_13-15-25.png

Howver, I'd recommend organizing data like what's shown on Sheet2 attached. You can then easily use pivottable and chart it out excluding month without data. Good data structure is key to accurate and fast analysis.
 

Attachments

  • Do Not Display Months with No Data.xlsx
    28.1 KB · Views: 5
In previous versions of Excel, I was able to take care of this simply by the "Text Axis" option under "Format Axis". However, your approach is just as good although rearranging the data my take a few extra minutes. Thanks a lot for your suggestion.
 
You must log in or register to reply here.
Back
Top