+ Reply to Thread
Results 1 to 5 of 5

Scatter chart line problem

  1. #1
    Registered User
    Join Date
    08-17-2010
    Location
    Occidental, CA, USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Scatter chart line problem

    I'm trying to graph a set of data pairs with a line joining points in the order of the x values. It's a stream longitudinal profile, with distance as the x value and elevation as the y value. I want a line joining the data points in the order of the x values, which increase from one value to the next. But the lines that show up jump all over the place, between points that aren't in sequence, and I can't seem to find a way to fix it. I've tried graphing it as a scatter plot and then adding a line, and as a scatter plot with a line, but neither one works.
    Attached Images Attached Images

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

    Re: Scatter chart line problem

    Are you required to use Excel? LO calc's chart engine has an option to "sort by x values".

    If you must use Excel, there is no similar setting in Excel. If you want the points connected in a certain order (in order of increasing X value, in this case), then you must sort the data points in the spreadsheet in the desired order. Your description of the problem does not indicate if you have already done this, or if you are not allowed to do this.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    08-17-2010
    Location
    Occidental, CA, USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Scatter chart line problem

    Yes, the points are sorted in order of increasing x value. This is a chart I've produced dozens of times for similar data over the past twenty or more years, which is why the problem is so vexing (and irritating). I've already checked that all the data is in number format as well.

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,499

    Re: Scatter chart line problem

    If you are certain the values are sorted in order of increasing x value, I don't think we will be able to debug what is going on from just a picture. Can you upload a sample file that illustrates the problem?

  5. #5
    Registered User
    Join Date
    08-17-2010
    Location
    Occidental, CA, USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Scatter chart line problem

    I checked that the data were in increasing x-value order and even did a sort to be sure, but it didn't change anything. But somehow closing the file and reopening it fixed the problem. I have no idea as to what was wrong, but it seems to be working now. Thanks for your help.

+ 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. Combining Chart together. One Scatter, one Scatter with Line
    By jp16 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-06-2019, 06:57 AM
  2. Custom scatter chart with a line
    By elyse13 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-08-2017, 07:34 PM
  3. [SOLVED] Combined line chart and scatter chart
    By sara ghaith in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-13-2012, 06:44 AM
  4. Excel 2007 : XY Scatter Chart - Line format problem
    By Carlsbergen in forum Excel General
    Replies: 3
    Last Post: 10-21-2011, 06:19 AM
  5. Combo Line & Scatter Chart
    By ClikClak in forum Excel General
    Replies: 10
    Last Post: 03-19-2010, 04:35 AM
  6. Scatter chart displays as line chart
    By Hannu in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-11-2006, 01:40 PM
  7. scatter chart insists on plotting as a line chart
    By Knows too little in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 03-11-2005, 03:06 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