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

Standard

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:

Excel Chart Hide Data 1Now, if I hide the data that is selected for this chart then the chart stops showing this as well:

Excel Chart Hide Data 2To 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 Excel Chart Hide Data 3
  3. Click on Hidden and Empty Cells Excel Chart Hide Data 4
  4. Check the Show data in hidden rows and columns check-boxExcel Chart Hide Data 5
  5. Go back to excel and you should see the data on the chart now even though the data is hidden Excel Chart Hide Data 6

Hope that helps!