Graph Plotting Zero Values

[muaythai]

Excel 2003.

I am wanting to prevent my graphs from plotting a value that equates to zero.

However the graphs use series that have formula in that will evaluate to zero until data is entered.

I have tried the following:-

1. Making the formula evaluate to "".

2. Checked for anything undet tools/options/chart.

3. Checked the chart sheets properties.

Surely this must be possible ? Anyone with any help would be much appreciated.

Thanks, MT.

 

[GlennUK]

Instead of having the formula evaluate to zero make it evaluate to NA().

For example:

=IF(A1=0,NA(),A1)