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

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

Bou wrote:

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, that worked.

Thank you a bunch!

Rgs,

Bou