|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
04-08-2005, 02:06 PM
|
|||
|
|||
|
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
04-08-2005, 03:06 PM
|
|||
|
|||
|
Re: Plotting blank cells that have functions in them.
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
04-10-2005, 07:06 PM
|
|||
|
|||
|
Re: Plotting blank cells that have functions in them.
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) > > >
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
