By default, charts in excel show filtered data only.
To show complete data i.e. to ignore filtering –
1. Right click on Chart and click on Select Data.
2. Click on Hidden and Empty Cells at the bottom
3. Select Show data in hidden rows and columns. Now, you will have the result which you want.
