## Continuous line in 2D chart?

119 Views 4 Replies Latest reply: Feb 13, 2014 1:58 PM by Jerrold Green1
Calculating status...
Currently Being Moderated
Feb 13, 2014 11:48 AM

Is there a way to have a 2D line chart link any disparate data points so the line is continuous?

• Level 4 (2,900 points)
Currently Being Moderated
Feb 13, 2014 12:01 PM (in response to 4thSpace)

I think what you are looking for is here:

You click on one data series (line) in the chart and make the selection.

SG

• Level 7 (27,345 points)
Currently Being Moderated
Feb 13, 2014 12:04 PM (in response to 4thSpace)

I would get rid of the rows, or hide them, where there is no data. Here's an example:

Table with blanks:

\T

Table with Blanks filtered out:

Jerry

• Level 6 (10,495 points)
Currently Being Moderated
Feb 13, 2014 12:32 PM (in response to 4thSpace)

Three possibilities:

1. Hide the rows with missing data
2. Remove the rows with missing data
3. Interpolate the missing data points and plot that data as a separate series. Remove the data symbol (the circle) and set the color to the same as your other line. In the screenshot below, I removed the data point symbols (the circles) but I left the line green.

• Level 7 (27,345 points)
Currently Being Moderated
Feb 13, 2014 1:58 PM (in response to 4thSpace)

4Sp,

It's also possible to convert this to a Scatter Chart, since your category entries are numeric. That would preserve the scale, as Badunit's interpolation option does, but the chart would do the interpolation work for you.

Yet another option would be to not use a line and let the reader's eye connect the dots. In that same vein, plot only points and add a trend line.

Jerry

#### More Like This

• Retrieving data ...

#### Legend

• This solved my question - 10 points
• This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.