Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

change horizontal axis starting date from 2008 to 2010

Latest post Mon, Mar 29 2010 6:30 AM by Teppic_. 1 replies.
  • Fri, Mar 26 2010 11:27 AM

    • mduncan53
    • Not Ranked
    • Joined on Fri, Mar 26 2010
    • Posts 1
    • Points 21

    change horizontal axis starting date from 2008 to 2010

    I have charted data using the =SERIES('All Graph'!$I$1,'All Graph'!$E$2:$E$9,'All Graph'!$I$2:$I$9,3) command.  However, the Y axis does not reflect the input data.  The input data is

    1/18/10
    2/4/10
    5/17/10
    1/1/10
    3/1/10
    1/1/10
    3/1/10

    but the Y axis starting point is 7/26/08.

     

     

    • Post Points: 21
  • Mon, Mar 29 2010 6:30 AM In reply to

    • Teppic_
    • Top 75 Contributor
    • Joined on Fri, Apr 3 2009
    • Posts 13
    • Points 145

    Re: change horizontal axis starting date from 2008 to 2010

    mduncan

     

    Right click on the axis and choose "format axis" or something similar.

    You can then choose a minimum for the scale... If you can't put a date into the minimum box (depends on the version of excel) then you will have to work out the number which equates to the day you want the scale to start from.

    01/01/2010 is "40179" ... it has something to do with the number of days since 01/01/1900

    To find the serial number which equates to a date the easiest way is to type something like:

    =VALUE("01/01/2010")

    into a cell. it will show the number which excel considers to be equivalent to the date you've put in the speech marks.

     

    Teppic

    Filed under: ,
    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.