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.