How suppress chart points - cells with formulae returning null

  • Thread starter Thread starter sarcastix
  • Start date Start date
S

sarcastix

I want to suppress chart points for a cumulative line graph of monthly
telephone costs where the particular month's values have not yet been entered
but there is a formula in the cell which currently returns null but will
return the value once it is posted on the accountmaster sheet.
 
Hi,

Use NA(). The will cause the data marker to be omitted. Note the line will
be interpolated between valid data points.
Something like this,

=IF( <test> , <value> , NA() )


Cheers
Andy
 
Back
Top