NA() is the usual workaround for this is, and it works great for line or
XY charts, but it will not work with an area chart as Lasci was using.

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

Flávio, SP, Brazil wrote:

Hi, Lasci, I´ve just done another workaround that was use na() function
instead and it did pretty well in my particular case. But, thanks a lot
anyway.

Best wishes,
Flávio.

"Lasci" wrote:


Hi,

The only work around I have found is to interpolate the missing values in
the spreadsheet myself (which is what excel does for the line chart) by using
some kind of average. Not ideal but gets around the problem relatively
quickly....

"Flávio, SP, Brazil" wrote:


Hi, Lasci,

I have the same difficulty.
Couldn´t anyone find a solution for Lasci´s problem yet?

Thanks,
Flávio

"Lasci" wrote:


In the line graphs, I have managed to make excel ignore the missing values,
but only by having another data set that has all the values in the graph, and
then blanking out this line by changing the colour. This is the only work
around I seem to have found so far.....

"Jon Peltier" wrote:


Unfortunately this trick is ineffective in an area chart. You can only make it work
with real blank cells. If you have some kind of lookup formula, you'll have to
delete the ones that have no returned data.

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

Pierre wrote:


Cannot you put #N/A in the cells containing 0 ??
I think it does not read these values