PDA

View Full Version : Line graph - ignore zero



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

anandbohra
11-05-2007, 06:05 AM
pl attach the workbook.
it gives better idea to solve problem

Bob Phillips
11-05-2007, 06:18 AM
Get your formula to return NA() for zero.

Sir Babydum GBE
11-05-2007, 11:32 AM
Lovely Jubley

That sorts it!

Cheers

BD