Suppress zeros from the data table of a chart

  • Thread starter Thread starter andy2004
  • Start date Start date
A

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
 
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
 
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
 
Hey....I got the syntax wrong, thats why it didn't work for me.

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