interpolating blank cells

S

stine_white

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.
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Publisher adding blank page when printing my booklet... 2
How to correct a #N/A in vlookup 1
Set as Default Template not working 0
Word 2007 flash screen upside down and Word2007 cannot be used 0
New Bug in Track Changes in Word 365 0
Dealing with a Pivot Table (when I don't want to) 0
Graphing Question: Blank Lines Problem ? 2
Blank Page After Envelope-Label Wizard 5

Top