View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Make a chart that ignores zero values

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((B120);(C12/B12);NA())

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

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

I get an error saying:
Error in the formula.

Marco