I dont want the "#N/A" error to show up in my spreadsheet though. I want to
see it as a blank

"Luke M" wrote:

Change your formula to:
=IF(D3="",NA(),D5-D3)

This will generate the #N/A error, which XL graphs ignore the data (since it
is, by definition, not applicable)

Note that if your cells were truly empty (and not containing formulas) you
would need to go to Tools-Options-Chart settings to change how your chart
handles empty cells.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Todd" wrote:

20 cells* across

"Todd" wrote:

I have created an excel file to track expenses. I have an if function which
is somehting like this: =if(D3="","",D5-D3). This way if there is no value in
D3 i get a blank in my 6th row. This is doen for 20 rows across my 6th row.

Now here is my problem. I have graphed that data but even though it shows up
as a blank in the cell is graphing it as a "zero" value. Is there a way to
make it register as a blank cell and not as a "zero"? Or is there a way i
can format my graph to not plot a value equal to zero?

anyhelp on this would be greatly appreciated