View Single Post
  #3  
Old April 24th, 2010, 01:36 AM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default 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'?