View Single Post
  #1   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.

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.