| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using COUNTIF to search for existence | Excel Worksheet Functions | |||
| Calculating only non-empty cells... | Excel Worksheet Functions | |||
| Sumif Cells Are Not Blank | Excel Worksheet Functions | |||
| pivot tables reports - altering display of (blank) cells | Excel Worksheet Functions | |||
| blank cells | Excel Discussion (Misc queries) | |||
Linear Mode
