I have an Excel file (using 2003) that has a row of entries for
actual expenditures for each month (months in columns).  I want to
calculate the cumulative expenditures, plot them when actual
expenditures are entered, and not plot them when actual expenditures
are not entered.  I cannot figure out how to do this with the IF
statement or conditional formatting.  Everything I try leads to a "$0"
which is then plotted.  (The fields are formatted as currency, so the
"$" is there.)

   If I just leave the cumulative expenditures field blank, then it
is not plotted, but I have to enter the formula for the last month
each month when I update the spreadsheet.

   Is there a way to do this?     Thanks, Alan