+ Reply to Thread
Results 1 to 1 of 1

Chart axis doesn't print date correctly

  1. #1
    Registered User
    Join Date
    03-18-2010
    Location
    Jacksonville, FL
    MS-Off Ver
    Excel 2003
    Posts
    11

    Chart axis doesn't print date correctly

    I'm using excel 2003. I have a chart. Column A of the spreadsheet is the date. I have selected the Date format as 04/21/11. The dates are all correct and range from 9/11/09 to 4/20/11. But the X axis of my chart displays starting with Jan 0, 1900. One hint is that I have headings for column A that are not dates ... but the X Values in each Series starts with A6 which eliminates the heading rows. When laying the mouse pointer on the beginning and ending of the charted lines I can see the dates and they are correct.

    Does anyone know what I could be doing wrong?
    Last edited by eddyq; 04-21-2011 at 03:07 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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