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

[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

 

[Jon Peltier]

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/
_______

 

[Guest]

Jon, that worked.

Thank you a bunch!

Rgs,

Bou