+ Reply to Thread
Results 1 to 2 of 2

Graphic Y = f(X) has become crazy !

  1. #1
    Registered User
    Join Date
    11-30-2009
    Location
    Versailles
    MS-Off Ver
    Excel v.X MAC
    Posts
    1

    Graphic Y = f(X) has become crazy !

    Hello everybody !

    I've using Excel since ages without any problem, for simple applications.

    For managing my car's maintenance, I created an EXCEL file composed of 2 sheets :
    - one sheet for my BMW
    - one sheet for my wife's HONDA

    I attached the file to my message.

    For both sheet, I enter in column A the date of the repair, and in column B the mileage. The rest deals with cost, operation, ...

    I created a graphic to show the evolution of mileage versus time, using a "cloud of points" graphic with curve.

    Everything was working fine until today, where the graph for my BMW desperately refuse to spot any point versus time !!! As you can see in the HONDA sheet, everything is still OK.

    If a change the X scale parameters, with Xmini=0 and Xmaxi=48, I can see the mileage values appearing, just like in a normal 'curve' graphic, this is not what I want (I really want X scale to be time, not number of samples !!!)

    If anybody has an idea of what's happening, I would be quite relieved !
    Thank you for your answers !
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Graphic Y = f(X) has become crazy !

    Check the date you have entered in A46
    Cheers
    Andy
    www.andypope.info

+ 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