| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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'? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if is null | Excel Discussion (Misc queries) | |||
| Failed to save table attributes of (null) into (null). | Excel Discussion (Misc queries) | |||
| COUNTIF says Null = Blank but Blank < Null | Excel Worksheet Functions | |||
| Truly Null | Excel Worksheet Functions | |||
| cell value based on null/not null in another cell | Excel Worksheet Functions | |||
![Jon Peltier[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
