I have a chart showing year to date figures. My underlying data picks up the date of the report and then shows month and ytd figures based on the month. To show the ytd figure, I have used the following formula:
=IF(L6="ok",SUM($C38:L38),"")
L6 is showing that the column is in ytd (date less than report date). The Sum gives me ytd if the column is in period and then returns blank if not.

The problem is that the chart is taking the blank as a zero, instead of a blank and rather than ending the chart at that point (which was my intention), is dropping the line to zero.

Any help please?

Thanks

Robert
Upgrading XP to Vista is like replacing Bill Clinton with Dubbya