Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am using Excel 2003
When a formula calculates a NULL or "", as the value in a cell such as in the case of the following expression, =IF(E34="","",E34) - if you plot a set of data generated by these entrys all of the NULLs are plotted as a Zero value. If I wanted Excel to plot a Zero it is easy enough to change the expressions to =IF(E34="",0,E34). Excel should not chart a NULL value. I can't find any discussion boards that can help me resolve this and it appears to be a considerable issue. Please provide a fix for this ASAP as it is very important to those of us who consistantly update charts. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Challenging Charting | Charts and Charting in Excel | |||
Contour plot | Charts and Charting in Excel | |||
Bar Chart Label Sizes | Charts and Charting in Excel | |||
how to enter a null cell value in a formula | Excel Worksheet Functions | |||
Charting time? help please... | Charts and Charting in Excel |