General if the cells are hidden, chart will not pull up that data
Use the following to make it active
1. Click the chart in which you want to display hidden data.
2. This displays the Chart Tools, adding the Design, Layout, and Format tabs.
3. On the Design tab, in the Data group, click Select Data.
1. Click Hidden and Empty Cells.
