interpolating blank cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

stine_white - 02 Nov 2006 17:50 GMT

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.

Reply to this Message

Bernard Liengme - 02 Nov 2006 20:12 GMT

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

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

>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
[quoted text clipped - 3 lines]
> the Tools:Options:Charts: Interpolate blank cells, but I can't get it to
> work. Please help. Thanks.

Reply to this Message