View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
Posts: 25
Default How do I ignore Graphs zero values.

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
How do I get the graph to ignore the zero values.

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