2

This question over on SuperUser is exactly the same as mine, in the sense that I have a CSV that contains gaps in each column, but I want to plot it as a continuous line. However, I'm using Numbers, not Excel. Is there a way to replicate those results using Numbers? The Format menu doesn't seem to have too many parameters to adjust regarding this.

The current workaround I have is to set the graph to "2D Area" (1), selecting the line itself in the graph, setting No Fill, and then setting the Stroke parameter. This achieves the intended effect (2), but doesn't scale well with multiple (overlapping) datasets.

Before, setting the graph to 2D Area Afterwards

And here's the data when enabling 2D Line

enter image description here

Improve this question
3
  • Is the ultimate aim that you actually want to plot the points for which there is no data? Or would it work just as well not plotting those points at all, so long as your line chart is a still a single solid line? – Monomeeth♦ Jul 20 '19 at 3:43
  • Have you tried plotting it as a 2d scatter plot? That may improve your results. – Natsfan Jul 20 '19 at 14:53
  • The idea is that I want to join the points together even across the gaps where there is no data available. Essentially, instead of clusters (like in the bottom image) I want a continuous line – Jeeter Jul 22 '19 at 16:59
1

You should plot the data using the 2d Scatter plot. This will draw a continuous line connecting the dta points.

I had some issues with scatter plot in Numbers but eventually got it working. I had problems sometimes getting to to use the correct x and y values. Maybe you won't encounter these issues.

Improve this answer
2
  • This still only connects the contiguous data together, rather than all the data – Jeeter Jul 22 '19 at 16:56
  • You need to delete the cells with no data and then it will connect all. You can sort the data on certain fields and this will result in all empty cells being grouped making them easy to delete. – Natsfan Jul 22 '19 at 17:53

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .