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