| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Not plotting blank cells with formulas until number appears
If a formula is in the cell but is blank or equals "0", how do you get a
chart not to plot until a number appears? |
|
#2
|
|||
|
|||
|
You can use an IF formula with NA(). For example:
=IF(OR(B2="",B2=0),NA(),B2-A2) The chart will interpolate over the #N/A errors. To hide these errors, you can use conditional formatting. http://www.contextures.com/xlCondFormat03.html#Errors Excel Charts and Formulas wrote: If a formula is in the cell but is blank or equals "0", how do you get a chart not to plot until a number appears? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
| Plotting blank cells in line charts? | Charts and Charting in Excel | |||
| how do you ignore blank cells in formulas | Excel Discussion (Misc queries) | |||
| Non Blank - Blank Cells???? | Excel Discussion (Misc queries) | |||
| In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) | |||
Hybrid Mode
