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
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.
