Not plot zero on line chart without using NA?
 

Is there any way to have a line chart ignore the zeros other than manipulate
the formula to show NA?

Not plot zero on line chart without using NA?
 

If there were, would we settle for using NA()? We've been asking for
something better for several versions of Excel.

There are two options: use NA() in the formula, or delete the formula
altogether.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Homer wrote:
Is there any way to have a line chart ignore the zeros other than manipulate
the formula to show NA?

Not plot zero on line chart without using NA?
 

That's what I thought, but I figured I'd take a shot at someone having a
slick work around. I guess NA is the slick work around.

Sounds like Microsoft is as reseptive to changing the headaches as Autodesk
is.

Thanks for the help.



"Jon Peltier" wrote:

If there were, would we settle for using NA()? We've been asking for
something better for several versions of Excel.

There are two options: use NA() in the formula, or delete the formula
altogether.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Homer wrote:
Is there any way to have a line chart ignore the zeros other than manipulate
the formula to show NA?