interpolating blank cells
 

I want to graph the data from a table, but I want the charts to interpolate
the lines inbetween the "blank" cells. All of the cells have formulas in
them because they are pulling the data from another worksheet, but some of
them appear blank because there is no data for that time slot. I have tried
the Tools:Options:Charts: Interpolate blank cells, but I can't get it to
work. Please help. Thanks.

interpolating blank cells
 

You see a cell with a formula is not blank
Replace you formula by =IF(your-formula="",NA(), your_formula)
Such as =IF(Sheet1A1="",NA(),Sheet!A1)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"stine_white" wrote in message
...
I want to graph the data from a table, but I want the charts to interpolate
the lines inbetween the "blank" cells. All of the cells have formulas in
them because they are pulling the data from another worksheet, but some of
them appear blank because there is no data for that time slot. I have
tried
the Tools:Options:Charts: Interpolate blank cells, but I can't get it to
work. Please help. Thanks.