I'm using an if statement within a data series that I then chart (excel
2003). The if statement is something like =if(A1=5,D2+D3,""). If the
statement is false, I would expect nothing to display in the cell which is
indead the case. However, when I plot the series in a line graph, it plots
that point as a Zero value. Using a =Isblank(Cell #) gives me a false which
leads me to believe that the cell is truely not blanked. How do I get the
formula to make the cell empty in the eyes of the chart? The Options in the
Tools drop down for not plotting blank cells is checked already (Chart Tab).

=if(A1=5,D2+D3,NA())
--
David Biddulph

"GoingBonkers" wrote in message
...
I'm using an if statement within a data series that I then chart (excel
2003). The if statement is something like =if(A1=5,D2+D3,""). If the
statement is false, I would expect nothing to display in the cell which is
indead the case. However, when I plot the series in a line graph, it plots
that point as a Zero value. Using a =Isblank(Cell #) gives me a false
which
leads me to believe that the cell is truely not blanked. How do I get the
formula to make the cell empty in the eyes of the chart? The Options in
the
Tools drop down for not plotting blank cells is checked already (Chart
Tab).

David - Thank you for the Help; That worked and with some Conditional
formatting I was able to only show the relevant data in the series.

"David Biddulph" wrote:

=if(A1=5,D2+D3,NA())
--
David Biddulph

"GoingBonkers" wrote in message
...
I'm using an if statement within a data series that I then chart (excel
2003). The if statement is something like =if(A1=5,D2+D3,""). If the
statement is false, I would expect nothing to display in the cell which is
indead the case. However, when I plot the series in a line graph, it plots
that point as a Zero value. Using a =Isblank(Cell #) gives me a false
which
leads me to believe that the cell is truely not blanked. How do I get the
formula to make the cell empty in the eyes of the chart? The Options in
the
Tools drop down for not plotting blank cells is checked already (Chart
Tab).