Thread: 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