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

J

Julian P.

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'?
 
J

Jon Peltier

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

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically sending multiple parts of text from one word doc to another - is possible. 0
Is this possible? 0
Doughnut Chart linked with the slicer in the pivot table 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
VBA - exporting serial letters to single documents 0
Is it possible to edit colours already saved as part of a custom theme? 0
Shared Link is showing empty notebook 1
Calculations with possible null value fields 1

Top