Suppress zeros from the data table of a chart

[andy2004]

I am plotting data on a monthly basis for a year from the result of som
calculations in the spreadsheet.....
So when it's April the values in the rest of the year are turned out a
#NA (a tip I saw on this forum just now....thanks).

However the data table under the chart still insists on displayin
these with a value of 0.

This would not be a problem if some of the charts didn't have expecte
perfromance levels of 0.

Anyone know how to turn these zeros off in the data table ?

Thanks in advance
Andy:confused

 

[Andy Pope]

Hi Andy,

Using the NA() function does not output zeros in the data table for me.
I'm using XL2000, which version are you using?

Cheers
Andy

 

[andy2004]

I'm using 97.... it must just be a version thing

Thanks for looking anyway
And

 

[Andy Pope]

Hi Andy,

Still no problem with Xl97.

With a dates in column B and formulas in column C like this

=IF($B7<NOW(),ROW()+1,NA())

It generate #N/A in the cell, a broken line and nothing in the data table.

What formula are you using?

Cheers

 

[andy2004]

Hey....I got the syntax wrong, thats why it didn't work for me.

Just tried it again and it works...your a sta