Excel 2013: Display hidden rows columns and data on an Excel Chart

If you hide rows, columns and data on excel, the chart that’s uses this data also hides it — while this is the default behavior, you can override this by following the steps below.

Let’s reproduce the behavior first.

I have a simple excel chart like shown below:

Now, if I hide the data that is selected for this chart then the chart stops showing this as well:

To fix this and if you want the cells (rows, columns and data) to be still hidden but still have the chart show up, then follow the steps:

1. Select the chart

2. Under Chart Tools > Design > Select Data 

   

3. Click on Hidden and Empty Cells 

   

4. Check the Show data in hidden rows and columns check-box

   

5. Go back to excel and you should see the data on the chart now even though the data is hidden 

   

Hope that helps!