Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Plotting blank cells that have functions in them.
How do I keep a chart from plotting blank cells that have a formula in them?
i.e. =IF(ISERROR(D2/D3),"",D2/D3) |
#2
|
|||
|
|||
Use the NA function, instead of an empty string, e.g.:
=IF(ISERROR(D2/D3),NA(),D2/D3) Spock wrote: How do I keep a chart from plotting blank cells that have a formula in them? i.e. =IF(ISERROR(D2/D3),"",D2/D3) -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Spock -
What Debra left out was that NA() produces an ugly #N/A error in the worksheet, even though it makes the chart look good. But she shows on her website how to hide the errors with conditional formatting: http://contextures.com/xlCondFormat03.html#Errors - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Debra Dalgleish wrote: Use the NA function, instead of an empty string, e.g.: =IF(ISERROR(D2/D3),NA(),D2/D3) Spock wrote: How do I keep a chart from plotting blank cells that have a formula in them? i.e. =IF(ISERROR(D2/D3),"",D2/D3) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
blank cells | Excel Discussion (Misc queries) | |||
Not plotting blank cells with formulas until number appears | Charts and Charting in Excel | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Plotting blank cells in line charts? | Charts and Charting in Excel | |||
In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) |