+ Reply to Thread
Results 1 to 2 of 2

Scatter Plot Min/Max Values in Numbers not Date

  1. #1
    Registered User
    Join Date
    01-22-2013
    Location
    N/A
    MS-Off Ver
    Excel 2007
    Posts
    9

    Scatter Plot Min/Max Values in Numbers not Date

    I've got a XY Scatter Plot with dates along the x-axis. I'd like to format it to make it a better fit (right now the minimum and maximum values are not lined up well). I go to make the Minimum and Maximum values for the x-axis fixed but those values are formatted in numbers as opposed to dates. The x-axis does display as dates so I don't know what the problem is here...thanks for the help in advance!

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: Scatter Plot Min/Max Values in Numbers not Date

    From http://office.microsoft.com/en-us/ex...240.aspx?CTT=1
    Microsoft Excel stores dates as sequential numbers that are called serial values. For example, in Microsoft Excel for Windows, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900. Excel stores times as decimal fractions because time is considered a portion of a day. The decimal number is a value ranging from 0 (zero) to 0.99999999, representing the times from 0:00:00 (12:00:00 A.M.) to 23:59:59 (11:59:59 P.M.).

    Because dates and times are values, they can be added, subtracted, and included in other calculations. You can view a date as a serial value and a time as a decimal fraction by changing the format of the cell that contains the date or time to General format.
    So the values you are seeing in minimum and maximum fields are these date/time serial numbers. I don't work with date/time serials very much, but I expect if you figure out what serial numbers correspond to your desired max and min values, you can enter those values into the max and min fields to get what you are after.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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