MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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