+ Reply to Thread
Results 1 to 2 of 2

How do I get the dates on an excel chart to stay as dates instead.

  1. #1
    Rani
    Guest

    How do I get the dates on an excel chart to stay as dates instead.

    On some of my Excel charts, the date series on the X axis changes
    automatically from a date format to serial numbers. Can anyone help me
    figure out why, pls?

  2. #2
    Jon Peltier
    Guest

    Re: How do I get the dates on an excel chart to stay as dates instead.

    If the data is in one workbook, and the chart in another, when the data
    workbook is closed, the chart can no longer find the right number
    format. Reopen the data workbook, activate the chart, double click the
    date axis, and click on the Number tab. If the number format is wrong,
    fix it there. In any case, uncheck the Linked to Source box, then click
    OK. Since you're no longer linked to source, the number format stays
    with the chart.

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Peltier Technical Services
    Tutorials and Custom Solutions
    http://PeltierTech.com/
    _______


    Rani wrote:

    > On some of my Excel charts, the date series on the X axis changes
    > automatically from a date format to serial numbers. Can anyone help me
    > figure out why, pls?


+ 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