Control the way empty cells are plotted

  1. On the Tools menu, click Options, and then click the Chart tab.
  2. Under Empty cells plotted as, click the option you want.

    For Help on an option, click the question mark and then click the option.