Ignoring blanks in Excel data

[Barend]

Hi,

I have a data sheet like this:

1 10 5
2 6
3 20
4 25
5 7
6

and I would like to plot last two columns against 1st colum as "x-axis".

But now all blanks are interpreted as zeroes. How to change the Excel settings, so that blanks are
ignored ?

Some help would be nice.

Bye.

 

[Roger Govier]

Hi

Enter =NA() in the blank cells, then carry out your plot.