zeros/"value" in cells messing my charts

[saziz]

Hi Guys n Gals,
I am trying to plot charts with macro. I am running into cells whic
does not have data instead it has those "value" kind of data you kno
when a formula doesn't work how it gives that garbelled value "######"
This is ruining my charts.
Any idea how I can get rid of these.
Thanks in advance.
Sazi

 

[Biff]

Saziz,

If you're getting #VALUE! errors that's telling you
something's wrong with a formula. You need to fix that.
But on the other hand, if that particular point is not
needed for the chart you need to trap the error and have
it return an NA(). Something like:

=IF(ISERROR(YOUR_FORMULA),NA(),YOUR_FORMULA)

Biff

 

[Jon Peltier]

Saziz -

In addition to Biff's comments, I thought I'd point out that ######
usually means the column isn't wide enough to display the cell's
contents. Though maybe it's just not wide enough to show an error.

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