|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 29th, 2003, 06:35 PM
|
|||
|
|||
Ignore " " values
The following formula (typical) provides point data for a
plotted series. Problem is, when the cell holding the data is blank (" "), the series drops to zero. Is there a way to have the chart ignor the " " values? =IF(Customer!U27"",Customer!U27,"") 
|
|
#2
October 29th, 2003, 08:06 PM
|
|||
|
|||
|
Ignore " " values
On Wed, 29 Oct 2003 10:35:29 -0800, Phil Hageman =
wrote: The following formula (typical) provides point data for a plotted series. Problem is, when the cell holding the data is blank (" "), the series drops to zero. Is there a way to have the chart ignor the " " values? =3DIF(Customer!U27"",Customer!U27,"") Relplace the "" with an N/A error. For example, =3DIF(Customer!U27"",Customer!U27,NA()) -- = Dave dvt at psu dot edu
|
|
#3
October 29th, 2003, 08:45 PM
|
|||
|
|||
|
Ignore " " values
Thanks, Dave. I used #N/A and it works. Thanks,Phil
-----Original Message----- On Wed, 29 Oct 2003 10:35:29 -0800, Phil Hageman wrote: The following formula (typical) provides point data for a plotted series. Problem is, when the cell holding the data is blank (" "), the series drops to zero. Is there a way to have the chart ignor the " " values? =IF(Customer!U27"",Customer!U27,"") Relplace the "" with an N/A error. For example, =IF(Customer!U27"",Customer!U27,NA()) -- Dave dvt at psu dot edu .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
