I have created a chart from 3 columns of data.
Two columns are complete, one column is built up gradually from data on another sheet. (Sheet 1)
All data is plotted correctly but an empty cell is treated as 0 and not ignored as I would like.
How can I get round this?
This is the function I am using in the incomplete column.

=IF(Sheet1!E2>0,Sheet1!E2,"")