Currently Being ModeratedFeb 13, 2014 12:32 PM (in response to 4thSpace)
- Hide the rows with missing data
- Remove the rows with missing data
- 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.
Currently Being ModeratedFeb 13, 2014 1:58 PM (in response to 4thSpace)
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.