Is it possible to define a null value (a la -999.25)?
 

I've often been 'hassled' with charts not being able to handle null data. Is
it possible to define a default null value that Excel charts will see as
'empty'?

Is it possible to define a null value (a la -999.25)?
 

Use =NA()
--
David Biddulph


"Julian P." <Julian wrote in message
...
I've often been 'hassled' with charts not being able to handle null data.
Is
it possible to define a default null value that Excel charts will see as
'empty'?

Is it possible to define a null value (a la -999.25)?
 

NA() isn't really empty or null, but at least some chart types do not
plot it.

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


On 4/23/2010 10:34 AM, David Biddulph wrote:
Use =NA()
--
David Biddulph


"Julian P."<Julian wrote in message
...
I've often been 'hassled' with charts not being able to handle null data.
Is
it possible to define a default null value that Excel charts will see as
'empty'?