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.