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:
- Select the chart
- Under Chart Tools > Design > Select Data
- Click on Hidden and Empty Cells
- Check the Show data in hidden rows and columns check-box
- Go back to excel and you should see the data on the chart now even though the data is hidden
Hope that helps!