Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |