software

I tried using #N/A in equation IF(B7=0,#N/A,B7) as to not show zeros in
chart, but still showed zeros. When I went to Tools/Options/Charts, the
Active Cells area was dimmed and I could not select quot;leave gapsquot;. Any
suggestions?
Thanks,

Hi,

Was the chart selected when you did Toolsgt;Options ?

Cheers
Andy

teds wrote:
gt; I tried using #N/A in equation IF(B7=0,#N/A,B7) as to not show zeros in
gt; chart, but still showed zeros. When I went to Tools/Options/Charts, the
gt; Active Cells area was dimmed and I could not select quot;leave gapsquot;. Any
gt; suggestions?
gt; Thanks,

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

Oops. No I didn't have it selected. Thanks. But I am having problems
setting up the Conditional Formating to hide the #N/A. I tried making color
white when cell=#N/A, but didn't work. Could you give me an example?
Thanks again.

quot;Andy Popequot; wrote:

gt; Hi,
gt;
gt; Was the chart selected when you did Toolsgt;Options ?
gt;
gt; Cheers
gt; Andy
gt;
gt; teds wrote:
gt; gt; I tried using #N/A in equation IF(B7=0,#N/A,B7) as to not show zeros in
gt; gt; chart, but still showed zeros. When I went to Tools/Options/Charts, the
gt; gt; Active Cells area was dimmed and I could not select quot;leave gapsquot;. Any
gt; gt; suggestions?
gt; gt; Thanks,
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.info
gt;

Assuming formula is in C7 the conditional formatting would be,

FormulaIs: =ISNA(C7)

Cheers
Andy

teds wrote:
gt; Oops. No I didn't have it selected. Thanks. But I am having problems
gt; setting up the Conditional Formating to hide the #N/A. I tried making color
gt; white when cell=#N/A, but didn't work. Could you give me an example?
gt; Thanks again.
gt;
gt; quot;Andy Popequot; wrote:
gt;
gt;
gt;gt;Hi,
gt;gt;
gt;gt;Was the chart selected when you did Toolsgt;Options ?
gt;gt;
gt;gt;Cheers
gt;gt;Andy
gt;gt;
gt;gt;teds wrote:
gt;gt;
gt;gt;gt;I tried using #N/A in equation IF(B7=0,#N/A,B7) as to not show zeros in
gt;gt;gt;chart, but still showed zeros. When I went to Tools/Options/Charts, the
gt;gt;gt;Active Cells area was dimmed and I could not select quot;leave gapsquot;. Any
gt;gt;gt;suggestions?
gt;gt;gt;Thanks,
gt;gt;
gt;gt;--
gt;gt;
gt;gt;Andy Pope, Microsoft MVP - Excel
gt;gt;www.andypope.info
gt;gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

Tried Formula is = isna(e54), and it returned Formula is -= quot;isna(e54)quot; .
Then made formating background blue just to see if it was recognizing value,
but did not get blue background. Actual formula in cell was
IF(e54=0,#N/A,e54). What should I try next?
Thanks
teds

quot;Andy Popequot; wrote:

gt; Assuming formula is in C7 the conditional formatting would be,
gt;
gt; FormulaIs: =ISNA(C7)
gt;
gt; Cheers
gt; Andy
gt;
gt; teds wrote:
gt; gt; Oops. No I didn't have it selected. Thanks. But I am having problems
gt; gt; setting up the Conditional Formating to hide the #N/A. I tried making color
gt; gt; white when cell=#N/A, but didn't work. Could you give me an example?
gt; gt; Thanks again.
gt; gt;
gt; gt; quot;Andy Popequot; wrote:
gt; gt;
gt; gt;
gt; gt;gt;Hi,
gt; gt;gt;
gt; gt;gt;Was the chart selected when you did Toolsgt;Options ?
gt; gt;gt;
gt; gt;gt;Cheers
gt; gt;gt;Andy
gt; gt;gt;
gt; gt;gt;teds wrote:
gt; gt;gt;
gt; gt;gt;gt;I tried using #N/A in equation IF(B7=0,#N/A,B7) as to not show zeros in
gt; gt;gt;gt;chart, but still showed zeros. When I went to Tools/Options/Charts, the
gt; gt;gt;gt;Active Cells area was dimmed and I could not select quot;leave gapsquot;. Any
gt; gt;gt;gt;suggestions?
gt; gt;gt;gt;Thanks,
gt; gt;gt;
gt; gt;gt;--
gt; gt;gt;
gt; gt;gt;Andy Pope, Microsoft MVP - Excel
gt; gt;gt;www.andypope.info
gt; gt;gt;
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.info
gt;

But if your worksheet formula is testing E54 for zero you need to apply
the formula to the cell that contains IF(e54=0,#N/A,e54) , which I would
assume is E55.
So CF FormulaIs would be =ISNA(E55)

teds wrote:
gt; Tried Formula is = isna(e54), and it returned Formula is -= quot;isna(e54)quot; .
gt; Then made formating background blue just to see if it was recognizing value,
gt; but did not get blue background. Actual formula in cell was
gt; IF(e54=0,#N/A,e54). What should I try next?
gt; Thanks
gt; teds
gt;
gt; quot;Andy Popequot; wrote:
gt;
gt;
gt;gt;Assuming formula is in C7 the conditional formatting would be,
gt;gt;
gt;gt;FormulaIs: =ISNA(C7)
gt;gt;
gt;gt;Cheers
gt;gt;Andy
gt;gt;
gt;gt;teds wrote:
gt;gt;
gt;gt;gt;Oops. No I didn't have it selected. Thanks. But I am having problems
gt;gt;gt;setting up the Conditional Formating to hide the #N/A. I tried making color
gt;gt;gt;white when cell=#N/A, but didn't work. Could you give me an example?
gt;gt;gt;Thanks again.
gt;gt;gt;
gt;gt;gt;quot;Andy Popequot; wrote:
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;gt;Hi,
gt;gt;gt;gt;
gt;gt;gt;gt;Was the chart selected when you did Toolsgt;Options ?
gt;gt;gt;gt;
gt;gt;gt;gt;Cheers
gt;gt;gt;gt;Andy
gt;gt;gt;gt;
gt;gt;gt;gt;teds wrote:
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;gt;I tried using #N/A in equation IF(B7=0,#N/A,B7) as to not show zeros in
gt;gt;gt;gt;gt;chart, but still showed zeros. When I went to Tools/Options/Charts, the
gt;gt;gt;gt;gt;Active Cells area was dimmed and I could not select quot;leave gapsquot;. Any
gt;gt;gt;gt;gt;suggestions?
gt;gt;gt;gt;gt;Thanks,
gt;gt;gt;gt;
gt;gt;gt;gt;--
gt;gt;gt;gt;
gt;gt;gt;gt;Andy Pope, Microsoft MVP - Excel
gt;gt;gt;gt;www.andypope.info
gt;gt;gt;gt;
gt;gt;
gt;gt;--
gt;gt;
gt;gt;Andy Pope, Microsoft MVP - Excel
gt;gt;www.andypope.info
gt;gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

I apologize, but in my attempt to simplify, I have caused confusion.
In E54 I have =IF(SUM(B5454)=0,#N/A,SUM(B5454)), which now gives
the answer #N/A.

In CF I entered Formula is = isna(e54), and it returned Formula is -=
quot;isna(e54)quot; .

I then formated cell in CF to be light blue color with red font just to see
if it recognized #N/A (goal is to have blank cell amp; not show zero value on
chart).

When closing CF, I still have #N/A showing, and the cell color is still
white with black font.

I am probably missing something very simple, but don't know what it is.

Thanks again for your help,quot;Andy Popequot; wrote:

gt; But if your worksheet formula is testing E54 for zero you need to apply
gt; the formula to the cell that contains IF(e54=0,#N/A,e54) , which I would
gt; assume is E55.
gt; So CF FormulaIs would be =ISNA(E55)
gt;
gt; teds wrote:
gt; gt; Tried Formula is = isna(e54), and it returned Formula is -= quot;isna(e54)quot; .
gt; gt; Then made formating background blue just to see if it was recognizing value,
gt; gt; but did not get blue background. Actual formula in cell was
gt; gt; IF(e54=0,#N/A,e54). What should I try next?
gt; gt; Thanks
gt; gt; teds
gt; gt;
gt; gt; quot;Andy Popequot; wrote:
gt; gt;
gt; gt;
gt; gt;gt;Assuming formula is in C7 the conditional formatting would be,
gt; gt;gt;
gt; gt;gt;FormulaIs: =ISNA(C7)
gt; gt;gt;
gt; gt;gt;Cheers
gt; gt;gt;Andy
gt; gt;gt;
gt; gt;gt;teds wrote:
gt; gt;gt;
gt; gt;gt;gt;Oops. No I didn't have it selected. Thanks. But I am having problems
gt; gt;gt;gt;setting up the Conditional Formating to hide the #N/A. I tried making color
gt; gt;gt;gt;white when cell=#N/A, but didn't work. Could you give me an example?
gt; gt;gt;gt;Thanks again.
gt; gt;gt;gt;
gt; gt;gt;gt;quot;Andy Popequot; wrote:
gt; gt;gt;gt;
gt; gt;gt;gt;
gt; gt;gt;gt;
gt; gt;gt;gt;gt;Hi,
gt; gt;gt;gt;gt;
gt; gt;gt;gt;gt;Was the chart selected when you did Toolsgt;Options ?
gt; gt;gt;gt;gt;
gt; gt;gt;gt;gt;Cheers
gt; gt;gt;gt;gt;Andy
gt; gt;gt;gt;gt;
gt; gt;gt;gt;gt;teds wrote:
gt; gt;gt;gt;gt;
gt; gt;gt;gt;gt;
gt; gt;gt;gt;gt;gt;I tried using #N/A in equation IF(B7=0,#N/A,B7) as to not show zeros in
gt; gt;gt;gt;gt;gt;chart, but still showed zeros. When I went to Tools/Options/Charts, the
gt; gt;gt;gt;gt;gt;Active Cells area was dimmed and I could not select quot;leave gapsquot;. Any
gt; gt;gt;gt;gt;gt;suggestions?
gt; gt;gt;gt;gt;gt;Thanks,
gt; gt;gt;gt;gt;
gt; gt;gt;gt;gt;--
gt; gt;gt;gt;gt;
gt; gt;gt;gt;gt;Andy Pope, Microsoft MVP - Excel
gt; gt;gt;gt;gt;www.andypope.info
gt; gt;gt;gt;gt;
gt; gt;gt;
gt; gt;gt;--
gt; gt;gt;
gt; gt;gt;Andy Pope, Microsoft MVP - Excel
gt; gt;gt;www.andypope.info
gt; gt;gt;
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.info
gt;

Ah I think I see the problem.
Make sure you include the ='s when entering the formula in CF. Otherwise
it will end up encased in double-quotes.

Cheers
Andy

teds wrote:
gt; I apologize, but in my attempt to simplify, I have caused confusion.
gt; In E54 I have =IF(SUM(B5454)=0,#N/A,SUM(B5454)), which now gives
gt; the answer #N/A.
gt;
gt; In CF I entered Formula is = isna(e54), and it returned Formula is -=
gt; quot;isna(e54)quot; .
gt;
gt; I then formated cell in CF to be light blue color with red font just to see
gt; if it recognized #N/A (goal is to have blank cell amp; not show zero value on
gt; chart).
gt;
gt; When closing CF, I still have #N/A showing, and the cell color is still
gt; white with black font.
gt;
gt; I am probably missing something very simple, but don't know what it is.
gt;
gt; Thanks again for your help,
gt;
gt;
gt; quot;Andy Popequot; wrote:
gt;
gt;
gt;gt;But if your worksheet formula is testing E54 for zero you need to apply
gt;gt;the formula to the cell that contains IF(e54=0,#N/A,e54) , which I would
gt;gt;assume is E55.
gt;gt;So CF FormulaIs would be =ISNA(E55)
gt;gt;
gt;gt;teds wrote:
gt;gt;
gt;gt;gt;Tried Formula is = isna(e54), and it returned Formula is -= quot;isna(e54)quot; .
gt;gt;gt;Then made formating background blue just to see if it was recognizing value,
gt;gt;gt;but did not get blue background. Actual formula in cell was
gt;gt;gt;IF(e54=0,#N/A,e54). What should I try next?
gt;gt;gt;Thanks
gt;gt;gt;teds
gt;gt;gt;
gt;gt;gt;quot;Andy Popequot; wrote:
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;gt;Assuming formula is in C7 the conditional formatting would be,
gt;gt;gt;gt;
gt;gt;gt;gt;FormulaIs: =ISNA(C7)
gt;gt;gt;gt;
gt;gt;gt;gt;Cheers
gt;gt;gt;gt;Andy
gt;gt;gt;gt;
gt;gt;gt;gt;teds wrote:
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;gt;Oops. No I didn't have it selected. Thanks. But I am having problems
gt;gt;gt;gt;gt;setting up the Conditional Formating to hide the #N/A. I tried making color
gt;gt;gt;gt;gt;white when cell=#N/A, but didn't work. Could you give me an example?
gt;gt;gt;gt;gt;Thanks again.
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;quot;Andy Popequot; wrote:
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;Hi,
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;Was the chart selected when you did Toolsgt;Options ?
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;Cheers
gt;gt;gt;gt;gt;gt;Andy
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;teds wrote:
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;I tried using #N/A in equation IF(B7=0,#N/A,B7) as to not show zeros in
gt;gt;gt;gt;gt;gt;gt;chart, but still showed zeros. When I went to Tools/Options/Charts, the
gt;gt;gt;gt;gt;gt;gt;Active Cells area was dimmed and I could not select quot;leave gapsquot;. Any
gt;gt;gt;gt;gt;gt;gt;suggestions?
gt;gt;gt;gt;gt;gt;gt;Thanks,
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;--
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;Andy Pope, Microsoft MVP - Excel
gt;gt;gt;gt;gt;gt;www.andypope.info
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;--
gt;gt;gt;gt;
gt;gt;gt;gt;Andy Pope, Microsoft MVP - Excel
gt;gt;gt;gt;www.andypope.info
gt;gt;gt;gt;
gt;gt;
gt;gt;--
gt;gt;
gt;gt;Andy Pope, Microsoft MVP - Excel
gt;gt;www.andypope.info
gt;gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

That was problem. Thanks again.

quot;Andy Popequot; wrote:

gt; Ah I think I see the problem.
gt; Make sure you include the ='s when entering the formula in CF. Otherwise
gt; it will end up encased in double-quotes.
gt;
gt; Cheers
gt; Andy
gt;
gt; teds wrote:
gt; gt; I apologize, but in my attempt to simplify, I have caused confusion.
gt; gt; In E54 I have =IF(SUM(B5454)=0,#N/A,SUM(B5454)), which now gives
gt; gt; the answer #N/A.
gt; gt;
gt; gt; In CF I entered Formula is = isna(e54), and it returned Formula is -=
gt; gt; quot;isna(e54)quot; .
gt; gt;
gt; gt; I then formated cell in CF to be light blue color with red font just to see
gt; gt; if it recognized #N/A (goal is to have blank cell amp; not show zero value on
gt; gt; chart).
gt; gt;
gt; gt; When closing CF, I still have #N/A showing, and the cell color is still
gt; gt; white with black font.
gt; gt;
gt; gt; I am probably missing something very simple, but don't know what it is.
gt; gt;
gt; gt; Thanks again for your help,
gt; gt;
gt; gt;
gt; gt; quot;Andy Popequot; wrote:
gt; gt;
gt; gt;
gt; gt;gt;But if your worksheet formula is testing E54 for zero you need to apply
gt; gt;gt;the formula to the cell that contains IF(e54=0,#N/A,e54) , which I would
gt; gt;gt;assume is E55.
gt; gt;gt;So CF FormulaIs would be =ISNA(E55)
gt; gt;gt;
gt; gt;gt;teds wrote:
gt; gt;gt;
gt; gt;gt;gt;Tried Formula is = isna(e54), and it returned Formula is -= quot;isna(e54)quot; .
gt; gt;gt;gt;Then made formating background blue just to see if it was recognizing value,
gt; gt;gt;gt;but did not get blue background. Actual formula in cell was
gt; gt;gt;gt;IF(e54=0,#N/A,e54). What should I try next?
gt; gt;gt;gt;Thanks
gt; gt;gt;gt;teds
gt; gt;gt;gt;
gt; gt;gt;gt;quot;Andy Popequot; wrote:
gt; gt;gt;gt;
gt; gt;gt;gt;
gt; gt;gt;gt;
gt; gt;gt;gt;gt;Assuming formula is in C7 the conditional formatting would be,
gt; gt;gt;gt;gt;
gt; gt;gt;gt;gt;FormulaIs: =ISNA(C7)
gt; gt;gt;gt;gt;
gt; gt;gt;gt;gt;Cheers
gt; gt;gt;gt;gt;Andy
gt; gt;gt;gt;gt;
gt; gt;gt;gt;gt;teds wrote:
gt; gt;gt;gt;gt;
gt; gt;gt;gt;gt;
gt; gt;gt;gt;gt;gt;Oops. No I didn't have it selected. Thanks. But I am having problems
gt; gt;gt;gt;gt;gt;setting up the Conditional Formating to hide the #N/A. I tried making color
gt; gt;gt;gt;gt;gt;white when cell=#N/A, but didn't work. Could you give me an example?
gt; gt;gt;gt;gt;gt;Thanks again.
gt; gt;gt;gt;gt;gt;
gt; gt;gt;gt;gt;gt;quot;Andy Popequot; wrote:
gt; gt;gt;gt;gt;gt;
gt; gt;gt;gt;gt;gt;
gt; gt;gt;gt;gt;gt;
gt; gt;gt;gt;gt;gt;
gt; gt;gt;gt;gt;gt;gt;Hi,
gt; gt;gt;gt;gt;gt;gt;
gt; gt;gt;gt;gt;gt;gt;Was the chart selected when you did Toolsgt;Options ?
gt; gt;gt;gt;gt;gt;gt;
gt; gt;gt;gt;gt;gt;gt;Cheers
gt; gt;gt;gt;gt;gt;gt;Andy
gt; gt;gt;gt;gt;gt;gt;
gt; gt;gt;gt;gt;gt;gt;teds wrote:
gt; gt;gt;gt;gt;gt;gt;
gt; gt;gt;gt;gt;gt;gt;
gt; gt;gt;gt;gt;gt;gt;
gt; gt;gt;gt;gt;gt;gt;gt;I tried using #N/A in equation IF(B7=0,#N/A,B7) as to not show zeros in
gt; gt;gt;gt;gt;gt;gt;gt;chart, but still showed zeros. When I went to Tools/Options/Charts, the
gt; gt;gt;gt;gt;gt;gt;gt;Active Cells area was dimmed and I could not select quot;leave gapsquot;. Any
gt; gt;gt;gt;gt;gt;gt;gt;suggestions?
gt; gt;gt;gt;gt;gt;gt;gt;Thanks,
gt; gt;gt;gt;gt;gt;gt;
gt; gt;gt;gt;gt;gt;gt;--
gt; gt;gt;gt;gt;gt;gt;
gt; gt;gt;gt;gt;gt;gt;Andy Pope, Microsoft MVP - Excel
gt; gt;gt;gt;gt;gt;gt;www.andypope.info
gt; gt;gt;gt;gt;gt;gt;
gt; gt;gt;gt;gt;
gt; gt;gt;gt;gt;--
gt; gt;gt;gt;gt;
gt; gt;gt;gt;gt;Andy Pope, Microsoft MVP - Excel
gt; gt;gt;gt;gt;www.andypope.info
gt; gt;gt;gt;gt;
gt; gt;gt;
gt; gt;gt;--
gt; gt;gt;
gt; gt;gt;Andy Pope, Microsoft MVP - Excel
gt; gt;gt;www.andypope.info
gt; gt;gt;
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.info
gt;

No worries, glad we got it sorted.

Cheers
Andy

teds wrote:
gt; That was problem. Thanks again.
gt;
gt; quot;Andy Popequot; wrote:
gt;
gt;
gt;gt;Ah I think I see the problem.
gt;gt;Make sure you include the ='s when entering the formula in CF. Otherwise
gt;gt;it will end up encased in double-quotes.
gt;gt;
gt;gt;Cheers
gt;gt;Andy
gt;gt;
gt;gt;teds wrote:
gt;gt;
gt;gt;gt;I apologize, but in my attempt to simplify, I have caused confusion.
gt;gt;gt;In E54 I have =IF(SUM(B5454)=0,#N/A,SUM(B5454)), which now gives
gt;gt;gt;the answer #N/A.
gt;gt;gt;
gt;gt;gt;In CF I entered Formula is = isna(e54), and it returned Formula is -=
gt;gt;gt;quot;isna(e54)quot; .
gt;gt;gt;
gt;gt;gt;I then formated cell in CF to be light blue color with red font just to see
gt;gt;gt;if it recognized #N/A (goal is to have blank cell amp; not show zero value on
gt;gt;gt;chart).
gt;gt;gt;
gt;gt;gt;When closing CF, I still have #N/A showing, and the cell color is still
gt;gt;gt;white with black font.
gt;gt;gt;
gt;gt;gt;I am probably missing something very simple, but don't know what it is.
gt;gt;gt;
gt;gt;gt;Thanks again for your help,
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;quot;Andy Popequot; wrote:
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;gt;But if your worksheet formula is testing E54 for zero you need to apply
gt;gt;gt;gt;the formula to the cell that contains IF(e54=0,#N/A,e54) , which I would
gt;gt;gt;gt;assume is E55.
gt;gt;gt;gt;So CF FormulaIs would be =ISNA(E55)
gt;gt;gt;gt;
gt;gt;gt;gt;teds wrote:
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;gt;Tried Formula is = isna(e54), and it returned Formula is -= quot;isna(e54)quot; .
gt;gt;gt;gt;gt;Then made formating background blue just to see if it was recognizing value,
gt;gt;gt;gt;gt;but did not get blue background. Actual formula in cell was
gt;gt;gt;gt;gt;IF(e54=0,#N/A,e54). What should I try next?
gt;gt;gt;gt;gt;Thanks
gt;gt;gt;gt;gt;teds
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;quot;Andy Popequot; wrote:
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;Assuming formula is in C7 the conditional formatting would be,
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;FormulaIs: =ISNA(C7)
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;Cheers
gt;gt;gt;gt;gt;gt;Andy
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;teds wrote:
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;Oops. No I didn't have it selected. Thanks. But I am having problems
gt;gt;gt;gt;gt;gt;gt;setting up the Conditional Formating to hide the #N/A. I tried making color
gt;gt;gt;gt;gt;gt;gt;white when cell=#N/A, but didn't work. Could you give me an example?
gt;gt;gt;gt;gt;gt;gt;Thanks again.
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;quot;Andy Popequot; wrote:
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;gt;Hi,
gt;gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;gt;Was the chart selected when you did Toolsgt;Options ?
gt;gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;gt;Cheers
gt;gt;gt;gt;gt;gt;gt;gt;Andy
gt;gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;gt;teds wrote:
gt;gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;gt;gt;I tried using #N/A in equation IF(B7=0,#N/A,B7) as to not show zeros in
gt;gt;gt;gt;gt;gt;gt;gt;gt;chart, but still showed zeros. When I went to Tools/Options/Charts, the
gt;gt;gt;gt;gt;gt;gt;gt;gt;Active Cells area was dimmed and I could not select quot;leave gapsquot;. Any
gt;gt;gt;gt;gt;gt;gt;gt;gt;suggestions?
gt;gt;gt;gt;gt;gt;gt;gt;gt;Thanks,
gt;gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;gt;--
gt;gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;gt;Andy Pope, Microsoft MVP - Excel
gt;gt;gt;gt;gt;gt;gt;gt;www.andypope.info
gt;gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;--
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;Andy Pope, Microsoft MVP - Excel
gt;gt;gt;gt;gt;gt;www.andypope.info
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;--
gt;gt;gt;gt;
gt;gt;gt;gt;Andy Pope, Microsoft MVP - Excel
gt;gt;gt;gt;www.andypope.info
gt;gt;gt;gt;
gt;gt;
gt;gt;--
gt;gt;
gt;gt;Andy Pope, Microsoft MVP - Excel
gt;gt;www.andypope.info
gt;gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info