OK, here's what's going on: Every day I enter numbers on my spreadsheet, and they are subtracted from yesterday's numbers to give me fuel used, water used, product made, etc, I've set the whole year up, and so if we enter a number for say Jan 17, it will subtract it from Jan 16 like it's supposed to. However, Jan 19 will subract from 18 and give me a negative number for the 19th. I fix this with an if function and if the cell is at or below zero, it will return a 0. Now I have a list of zeros in all my dates not used yet, and these are being trended on the chart as zeros, for the rest of the year. If this test could return an "empty" cell, then the chart would not see it and I wouldn't have the line of zeros from Jan 18-Dec 31. I've tried the " ", and even though the cell appears empty, it will chart as a zero. I've also tried the options tab on the chart window to try and tell not to plot/not plot empty cells, but I need empty cells. Does this help with my situation at all?