View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
fishy fishy is offline
external usenet poster
 
Posts: 39
Default How do I ignore Graphs zero values.

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