Make a chart that ignores zero values

  • Thread starter Thread starter Co
  • Start date Start date
Hi,

Select the chart and then via Tools > Options > Chart > Plot empty cells as
Interpolated.

But this will only may a difference if you cells are truly empty. If they
contain formula or text that setting will have no effect.
Instead you need to use NA() instead of ""

Cheers
Andy
 
Plot from =IF((B4>0),(C4/B4),NA()) instead of  =IF((B4>0),(C4/B4),"")
Click to expand...

When I do this:

=IF((B12>0);(C12/B12);NA())

I get an error in the empty field:
#NAME?

If I do this in the field:
=IF((B12>0),(C12/B12),NA())

I get an error saying:
Error in the formula.

Marco
 
NA() and #N/A may have a different representation in a non-English
localization of Excel. Look up the "Information Function" for an error that
means "no value is available". and use this in your formula.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


---------------------------------
When I do this:

=IF((B12>0);(C12/B12);NA())

I get an error in the empty field:
#NAME?

If I do this in the field:
=IF((B12>0),(C12/B12),NA())

I get an error saying:
Error in the formula.

Marco
 
Back
Top