+ Reply to Thread
Results 1 to 2 of 2

Line Graph - Excel doesnt like non-constant increments

  1. #1
    Registered User
    Join Date
    01-20-2011
    Location
    Engaldn
    MS-Off Ver
    Excel 2003
    Posts
    3

    Line Graph - Excel doesnt like non-constant increments

    Hi,

    Im having real trouble with my excel graph.


    RPM: 000-087-132-172-230-266-312
    TMP: 000-065-120-155-162-220-260

    I simply want a graph of RPM against TMP (temperature). However, excel doesnt like it, because the temp doesnt increment evenly, sometimes the value increments by 60, sometimes 30. However, on the bottom axis, is spaces them equally.

    How can I plot these on a line graph, with the TMP accuratley represented (spaced) across the bottom bar?

    http://img35.imageshack.us/img35/7365/helpvr.jpg

    Thank you for any help you can give.

    James
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-02-2009
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    22

    Re: Line Graph - Excel doesnt like non-constant increments

    You need to rather creat a scatter graph.

+ 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