View Single Post
  #2  
Old April 23rd, 2010, 03:34 PM posted to microsoft.public.excel.charting
David Biddulph
external usenet poster
 
Posts: 8,714
Default 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'?