Sir Babydum GBE
11-05-2007, 05:30 AM
I have a graph where the source data points to week/ending results - some of which haven't happened yet. If on the source sheet a cell is blank (and has no formula) then that total doesn't show on a line graph - I.e - the line stops where the last recorded data is.
But if there is a formula - even if it returns an open string, the line graph drops to zero for that week - and i don't want this to happen.
But I don't want to be filling in the formula every week - So what do I need to put in a sum() formula so that if the result is 0 (because the week hasn't happened yet and so there are no figures) I can return something that isn't interpreted as a zer by a line graph?
Thanks
BD
But if there is a formula - even if it returns an open string, the line graph drops to zero for that week - and i don't want this to happen.
But I don't want to be filling in the formula every week - So what do I need to put in a sum() formula so that if the result is 0 (because the week hasn't happened yet and so there are no figures) I can return something that isn't interpreted as a zer by a line graph?
Thanks
BD