I've read a lot of answers to this question, which all suggest using =na() so that the graph doesn't plot any data for the relevant cells, however, despite having #N/A in the relevant cells, even though nothing visable is plotted, the plotted graph data is still pushed to one side and if showing a legend, items still appear for the #N/A entries.

For example if the first four rows of data contain =na() producing a #N/A in those cells and the next six rows contain actual data, when the graph is plotted, the six plotted entries are pushed to the right because allowance is still being made for the first four rows.

Is there any way to completely not plot cells containing #N/A (as if they weren't in the data set at all and for the #N/A cells not to appear in the legend?