software

I have a graph in which I use NA() to skip plotting, but below the graph I
have to show the values. I tried conditional formatting to white out the
#N/A (ISNA(XXX) with no success. It whites out everything. Here's what I
need: IF there is a value, show it in the cell AND plot it. If the cell
value is #N/A, white it out and DON'T plot it.

Thanks.........TomCat

Try this, assume the cell in question is A1

then formatgt;conditional formatting, formula is

=ISNA(A1)

then format white fonts

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;TomCatquot; gt; wrote in message
...
gt;I have a graph in which I use NA() to skip plotting, but below the graph I
gt; have to show the values. I tried conditional formatting to white out the
gt; #N/A (ISNA(XXX) with no success. It whites out everything. Here's what I
gt; need: IF there is a value, show it in the cell AND plot it. If the cell
gt; value is #N/A, white it out and DON'T plot it.
gt;
gt; Thanks.........TomCatGot it......THANK YOU!

quot;Peo Sjoblomquot; wrote:

gt; Try this, assume the cell in question is A1
gt;
gt; then formatgt;conditional formatting, formula is
gt;
gt; =ISNA(A1)
gt;
gt; then format white fonts
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Northwest Excel Solutions
gt;
gt; www.nwexcelsolutions.com
gt;
gt; (remove ^^ from email address)
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;TomCatquot; gt; wrote in message
gt; ...
gt; gt;I have a graph in which I use NA() to skip plotting, but below the graph I
gt; gt; have to show the values. I tried conditional formatting to white out the
gt; gt; #N/A (ISNA(XXX) with no success. It whites out everything. Here's what I
gt; gt; need: IF there is a value, show it in the cell AND plot it. If the cell
gt; gt; value is #N/A, white it out and DON'T plot it.
gt; gt;
gt; gt; Thanks.........TomCat
gt;
gt;