When data is hidden in your table, Excel does not ... Select the chart, then click the Chart Design tab. Click the Select Data button. Click the Hidden and empty cells button.