How to omit data in a chart when there are error values?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there!

I've created a chart based on data who's values are variable. In certain
cases the data on one end can show error values (#DIV0!, #NUM, etc..). In
those cases the chart sees them as zero values.

Is there a way to automatically omit these values from the chart without
manually changing the series range?

Thank you!

Bou
 
Bou -

You can test for an error:

=IF(ISERROR(<expression>),NA(),<expression>)

This way you get the #N/A error, which is not such a problem for a chart.

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