+ Reply to Thread
Results 1 to 5 of 5

Excel 2007 : Excel 2007 Chart adding dates to X-Axis which are not in selected data range

  1. #1
    Registered User
    Join Date
    12-09-2008
    Location
    Tucson, AZ
    MS-Off Ver
    Office 2013
    Posts
    37

    Excel 2007 Chart adding dates to X-Axis which are not in selected data range

    I'm in the process of converting a workbook from the 2003 version of Excel to the 2007 version as we're in the middle of upgrading our office. Our workbook was working perfectly until I converted it to the *.xlsx version.

    Our preference is to be able to use some of the new features of the 2007 version of Excel. So now I am in need of recreating the workbook from scratch. I'm ok with it as I can now clean it up a bit and make full use of the 2007 feature set.

    I've done some Google searching and can't find anything about this problem that I am experiencing.

    I have a worksheet within the workbook that has 2 weeks of dates, actually 9 working days in it and they are setup across the columns, E6 through M6.

    Day #1 is 2/2/09 (E6)
    Day #9 is 2/12/09 (M6)

    The data being charted is in E7 through M7

    2/7 and 2/8 are obviously a weekend and therefore are not included in my data in the worksheet.

    I'm now charting the data for this period of time and the chart is including 2/7 and 2/8 on my X-Axis of the line chart even though they are not included in the data contained in E6 through M6. Is there a way to not have the chart add these 2 dates to the X-Axis? What am I missing?

    It makes the chart an eye sore to look at.

    Thanks in advance for any assistance.

    Chris
    Last edited by Ra21V12eN; 02-04-2009 at 01:35 PM.

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

    Re: Excel 2007 Chart adding dates to X-Axis which are not in selected data range

    When using dates as the x axis labels excel turns the axis in to a Time series rather than Category axis.
    To get a Category axis in xl2007 select the x axis. CTRL+1 to display Format dialog. Axis Options section has a Axis Type setting, which should be Text.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    12-09-2008
    Location
    Tucson, AZ
    MS-Off Ver
    Office 2013
    Posts
    37

    Re: Excel 2007 Chart adding dates to X-Axis which are not in selected data range

    EXCELLENT!!!

    Thank you very much...

    Issue Solved!!!

  4. #4
    Registered User
    Join Date
    11-05-2012
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Excel 2007 : Excel 2007 Chart adding dates to X-Axis which are not in selected data ra

    but when i did so my X axis length cannot be shorten... please help me in this.

  5. #5
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,147

    Re: Excel 2007 : Excel 2007 Chart adding dates to X-Axis which are not in selected data ra

    stalinsamuel,

    Welcome to the Forum, unfortunately:

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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