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.