Follow the steps below to show charts with hidden data cells in Excel. Select the chart, then click the Chart Design tab. Click the Select Data button. Click the Hidden and empty cells button.

Select Insert from the menu, and in the charts group, select the type of chart you want to add to the report sheet. In the Chart Design menu, in the Data group, select Select Data .

In the Charts group, select the type of chart you want to create. From there, give your chart a name. You can also do any additional formatting you would like, including choosing from more than a ...