Charting should not plot NULL as a zero

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Please provide a fix for this ASAP as it
is very important to those of us who consistantly update charts.
Click to expand...

You make it sound like you are addressing the Microsoft Excel Development
Team, whereas in fact you are generally addressing a group of volunteers who
happily give up their spare time to help other people get the best out of a
product that we enjoy using, albeit we also still learn a great deal from
what we see in here.

That having been said, try using =IF(E34="",NA(),E34)

Won't work for an Area chart though.
 
Back
Top