How to make chart not plot blank cells

[JLB123]

Hi,

For example, if the table below represents all the data I have selected for the chart to plot.

However, I do not want the chart to plot the values of the 1st and 5th rows (where there is no data in either cell), as for my data range that means the actual data part is highly compressed and you can't see it.

Is there an easy solution to this, or do I need to try and find a double offset solution?

Thanks

BLANK	BLANK
1	5
2	6
3	7
BLANK	BLANK

<tbody>
</tbody>

 

[elmer007]

You can have the chart plot nothing (instead of zero) by putting: =NA() into the blank cells.

 

[henrik2h]

Make a separate section for the chart data where you enter an if-formula

=if(and(isnumber(A1);isnumber(B1));A1;#N/A)

and the same for other columns. Then the chart will not show "zero" entries.