Prev: chart disappears in Vista
Next: Trendline in Stacked Column Chart
From: Julian P. Julian on 23 Apr 2010 10:19
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'?
From: "David Biddulph" groups [at] on 23 Apr 2010 10:34
Use =NA()
--
David Biddulph


"Julian P." <Julian P.(a)discussions.microsoft.com> wrote in message
news:3041EBD5-FD83-4BBE-834F-14E296CF6741(a)microsoft.com...
> 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'?


From: Jon Peltier on 23 Apr 2010 20:36
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 P.(a)discussions.microsoft.com> wrote in message
> news:3041EBD5-FD83-4BBE-834F-14E296CF6741(a)microsoft.com...
>> 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'?
>
>
 | 
Pages: 1
Prev: chart disappears in Vista
Next: Trendline in Stacked Column Chart