numbers help
Is there an equivalent in Numbers to Excel's "Connect data points with line" for formatting a chart with empty cells in the data sheet?
Question marked as
Top-ranking reply
There is not.
If in your table you hide the rows with no data, it will not chart those rows and it will connect all the other points. But if you want those rows to take up space on the X axis (assuming this is a line/category chart), this won't do what you want.
It is not too much trouble to interpolate a single missing point between two good points so it can be plotted but I don't know if anyone here has come up with a way to interpolate across several (an unknown number of) blank rows. Will you have two or more missing points clustered together or only one at a time?
This question comes up from time to time and it would be nice if Numbers would add the feature. You can request it using the menu item Numbers->Provide Numbers Feedback.