View Single Post
  #1   Report Post  
mrbella
 
Posts: n/a
Default Charting should not plot NULL as a zero

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.