Control the way empty cells are plotted

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.