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.
And here's the data when enabling 2D Line