Show empty cells as Lets you specify how you want empty worksheet cells in a data series to be shown in the chart.Gaps Leaves gaps for empty worksheet cells in a data series, which results in a segmented line. Zero Treats empty worksheet cells in a data series as zero values, so that the line drops to zero for zero-value data points. Connect data points with line Instead of leaving gaps in the line for empty worksheet cells in a data series, the gaps are filled with a connecting line.

Show data in hidden rows and columns Select this check box if you want values in rows or columns that are hidden on the worksheet to be plotted in the chart. When this check box is cleared (default setting), the chart displays only values in cells that are visible on the worksheet. You may want to use this setting with the outlining features in Excel to make parts of the chart appear and disappear.