Jon

I have done this but in an earlier discussion Andy suggested after doing the

formula you: " Use conditional formating to hide the #N/A". THis is the part

I cannot get to work. Whatever version of N/A I use I cannot fomat it.

"Jon Peltier" wrote:

Use the Is Formula option, and this formula, where the active cell is A1

=ISNA(A1)

- Jon

-------

Jon Peltier, Microsoft Excel MVP

Tutorials and Custom Solutions

http://PeltierTech.com

_______

"AR" wrote in message

...

I have tried doing a conditional format on the #N/A but it does not seem to

work. What do you need to specifically put in the conditional format. I

have

tried #N/A, NA(), N/A ?

"fishy" wrote:

Working thanks - as you said, already tried the first suggestion but as

it

was a formulae, it still showed.

"Andy Pope" wrote:

Hi,

That will not work is the cells actually contain zero because by

definition containing zero is NOT empty.

The zeros will either need to be removed from the cells or replaced

with

NA().

=IF(SUM(myrange)=0,NA(),SUM(myrange))

Use conditional formating to hide the #N/A

Cheers

Andy

R..VENKATARAMAN wrote:

select the chart.

goto tools options and check plot empty cells as any of the three

chices

given there.

"fishy" wrote in message

...

I have a variety of tables in excel that sum approx 20 sheets but

occasionally these have a zero value.

The graphs link off these tables and show drops to zero on these

occurences.

How do I get the graph to ignore the zero values.

The source table formula is too long to put an if arguement in.

--

Andy Pope, Microsoft MVP - Excel

http://www.andypope.info