If you wonder why your graphs vanish after you hide or filter data, you are in the right place. In this guide, we’re going to show you How to show hidden data in chart in Excel.

Download Workbook

Why does a chart not show hidden data?

This is a feature and default behavior of Excel to see what is happening on a chart while filtering data. And yes; Excel literally hides rows to filter out unwanted values.

How to show hidden data?

Thankfully, you can alter this behavior with a simple option. Just follow the steps.

  1. Right-click on the chart and click Select Data… from the context menu.
  2. Click the Hidden and Empty Cells button in the Select Data Source dialog box.
  3. Check Show data in hidden rows and columns in the Hidden and Empty Cells Settings dialog box.
  4. Click OK buttons to apply the change.
    How to show hidden data in chart in Excel