+ Reply to Thread
Results 1 to 3 of 3

How to Delete Blank Horizontal Category (Axis) Labels

  1. #1
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    How to Delete Blank Horizontal Category (Axis) Labels

    Hi..

    I have a number of Line Charts that show Sales and Wages related historical data...

    For some reason.. some of the Line Charts have got extra (unwanted) Horizontal Category(Axis) Label entries in the "Select Data Source" popup..

    These extra (unwanted) Horizontal Category(Axis) Label entries show as being blank but when i press edit they are linked to data..

    Basically.. on the attached Workbook.. all Line Charts that are on the 2 History sheets (Catering History and Bar History).. should only show July to June.

    The issue is that some have 2 -4 extra Category entries to the right of June.. I just can't seem to get rid of them..

    Hopefully someone has encountered this before and can help me..
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: How to Delete Blank Horizontal Category (Axis) Labels

    Series "2012-13" contains repeated and out of sync data points.

    =SERIES("2012-13",(Data!$L$5,Data!$L$9,Data!$L$13,Data!$L$17,Data!$L$21,Data!$L$25,Data!$L$29,Data!$L$33,Data!$L$37,Data!$L$41,Data!$L$45,Data!$L$49),(Data!$D$6,Data!$D$10,Data!$D$14,Data!$D$18,Data!$D$22,Data!$D$26,Data!$D$30,Data!$D$30,Data!$D$31,Data!$D$35,Data!$D$39,Data!$D$43,Data!$D$47,Data!$D$50,Data!$D$50,Data!$D$51),2)
    Cheers
    Andy
    www.andypope.info

  3. #3
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: How to Delete Blank Horizontal Category (Axis) Labels

    Ahh.. you're a lifesaver...

    Charts are my Achilles heal for sure.. thanks for that..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to add secondary horizontal (category) axis in a chart?
    By S K ROY in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-09-2012, 07:13 AM
  2. Category x axis labels not displaying
    By tezread in forum Excel General
    Replies: 12
    Last Post: 10-21-2010, 06:30 AM
  3. Category Labels(X) axis on a chart:
    By Ali in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-19-2006, 07:55 AM
  4. alignment of y axis category labels
    By philcud in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-09-2005, 03:05 PM
  5. [SOLVED] Bar chart & Category (x) axis labels
    By Airi A. in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-15-2005, 12:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1