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.
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.