+ Reply to Thread
Results 1 to 2 of 2

Charting with dates

  1. #1
    Registered User
    Join Date
    06-14-2006
    Posts
    72

    Charting with dates

    I am trying to chart some data and I want the dates starting with 3/1/06, 4/1/06,5/1/06,6/1/06 across the bottom and instead I am getting 1/6/1900,
    2/6/1900 and so on
    can anyone help with this?

    thks,

    Ed

  2. #2
    Kelly O'Day
    Guest

    Re: Charting with dates

    Changetires:

    It sounds like you want to make a trend chart, dates along X axis, values on
    Y axis.

    Your 1/6/1900 indicates that Excel does not recognize your dates. Excel uses
    1/1/1900 as starting point for calendar. Dates are stored as serial number
    of days since 1/1/1900. You'll need to examine your dates to see why they
    are not being recognized as dates.

    ...Kelly



    "changetires" <changetires.2a6knz_1151613002.7474@excelforum-nospam.com>
    wrote in message
    news:changetires.2a6knz_1151613002.7474@excelforum-nospam.com...
    >
    > I am trying to chart some data and I want the dates starting with
    > 3/1/06, 4/1/06,5/1/06,6/1/06 across the bottom and instead I am getting
    > 1/6/1900,
    > 2/6/1900 and so on
    > can anyone help with this?
    >
    > thks,
    >
    > Ed
    >
    >
    > --
    > changetires
    > ------------------------------------------------------------------------
    > changetires's Profile:
    > http://www.excelforum.com/member.php...o&userid=35414
    > View this thread: http://www.excelforum.com/showthread...hreadid=557099
    >




+ 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