+ Reply to Thread
Results 1 to 2 of 2

Lines end on different points.

  1. #1
    Registered User
    Join Date
    09-02-2015
    Location
    London
    MS-Off Ver
    2003
    Posts
    1

    Lines end on different points.

    Hello guys, I'm new to this forum, therefore I would like to apologise if this post happens to be in the wrong department so to say.

    I'm experiencing trouble with a Line chart in Excel 2003.
    For a school assignment we have 10 different thermometers, who monitor the temperatures of different areas at different times.
    These are all saved in an Excel file automatically.

    Now I have been making line charts of this data, but not all thermometers generate the same amount of measurements.
    So thermometer 1, for example, might have made 300 measurements and thermometer 2 might have made 400.

    Due to this, the line of the different Thermometers end up ending in different positions (most measurements ends last, least measurements ends first).

    I have been trying to get it connected to time, by using the option to format cells to time and by making the horizontal axis time bound as well,
    but the very same problem same to arise every time.

    Any ideas?

    Thanks

    Sorry for the spelling mistakes, not a native speaker

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,477

    Re: Lines end on different points.

    A spreadsheet that illustrates your problem would be helpful.

    In 2003 and earlier, the description "time axis" for line charts was a misnomer. The chart looks at dates only, not times. If I understand what you are trying to do, I think the problem goes away if you change your chart type to XY scatter instead of line.
    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)

Similar Threads

  1. Calculating angles between 2 lines made of 3 points in 3-D (x,y,z)
    By mkoaao in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-01-2015, 01:51 PM
  2. Drawing lines between several points in sequence
    By dode74 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2015, 04:47 PM
  3. plot pairs of time points as lines
    By bream in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-01-2013, 12:10 PM
  4. How to add joining lines between points in an XYplot
    By XcelGirl in forum Excel General
    Replies: 4
    Last Post: 04-29-2011, 05:54 AM
  5. How to find intersection points between lines using Excel?
    By Saurabh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-16-2006, 12:55 PM
  6. Plot order of lines and points in XY scatterplots
    By Elizabeth in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-01-2006, 06:10 PM
  7. referencing lines and series points
    By medicenpringles in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-28-2005, 07:05 PM

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