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