Spock

Posts: n/a

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)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
blank cells	R.VENKATARAMAN	Excel Discussion (Misc queries)	1	April 6th 05 10:25 AM
Not plotting blank cells with formulas until number appears	Excel Charts and Formulas	Charts and Charting in Excel	1	April 1st 05 12:58 AM
Blank Cells in Pivot Tables	Greg	Excel Discussion (Misc queries)	1	March 16th 05 09:23 PM
Plotting blank cells in line charts?	doogie	Charts and Charting in Excel	3	February 16th 05 05:06 PM
In Exel 2000, stop the blank cells (with formulas) from printing.	tonyoc	Excel Discussion (Misc queries)	1	December 10th 04 12:38 AM

All times are GMT +1. The time now is 04:25 AM.

About Us

"It's about Microsoft Excel"