Control the way empty cells are plotted
On the
Tools
menu, click
Options
, and then click the
Chart
tab.
Under
Empty cells plotted as
, click the option you want.
For Help on an option, click the question mark
and then click the option.