1

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

  • 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 at 3:43
  • Have you tried plotting it as a 2d scatter plot? That may improve your results. – jmh Jul 20 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 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.

  • This still only connects the contiguous data together, rather than all the data – Jeeter Jul 22 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. – jmh Jul 22 at 17:53

You must log in to answer this question.

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