Ignoring zeroes in charts


Posted by Tim Grollman on July 04, 2001 9:49 AM

I've forgotten where in the chart options you can tell Excel to ignore values that are zero, to save the line plummeting down to the ground and up again. Can anyone remind me please?



Posted by Ivan F Moala on July 04, 2001 8:30 PM

Tools / Options / Chart