Pivot Chart Doesn't Show The Entries For The Selected Year On The Slider

[zanshin777]

On the Reports page and on the Slider when you choose September, October, November, December (on the first slider) in the year of 2020 (on the second slider) It shows how many entries are there in the regarded dates. (Referencing G and H columns in the page named Done)

However when you choose September (on the first slider) in the year of 2021 (on the second slider) It doesn't show anything. (Actually there are 6 entries for the September 2021)

Why? And How can I fix it?

[JeteMc]

I feel as if the problem is that the source for the pivot table may be Done!A1:H102.
Try resizing the table to A1:H277 and then refresh the pivot table [and chart if necessary]
Let us know if you have any questions.

[zanshin777]

I noticed the problem. The entries which aren't shown up in the Pivot Chart are also not part of the Pivot Table.

How can I add them into the Pivot Table?

I Cut/Paste Row Entries from another page into this Pivot Table. But It looks like It does not add them into Pivot Table automatically. Maybe I need to create a Pivot Table which has infinite! rows.

How can I fix this problem?

[JeteMc]

Paste the rows into table 14 on the Done sheet.
Select Resize Table to check and make sure that the table includes all rows.
Select a cell in the pivot table and select Refresh All from the pivot table analyze tab.
Let us know if you have any questions.

[zanshin777]

While refreshing I get this error;

"Cannot open PivotTable source file"

???

[JeteMc]

When I opened the file and attempted to refresh I saw that the source was set to: '[TODO LIST.xlsx]Done'!$A:$H
The file is now called TODO LIST COPY 2.xlsx so the file name is not pointing to the correct file.
I feel that the easiest fix is changing the source data for the pivot table/chart to: Table14
Let us know if you have any questions.

[zanshin777]

I noticed It doesn't update the new File Name automatically. So I have to change that manually.

Then It works.

Thank you very much for the answers.

[JeteMc]

You're Welcome and thank you for the feedback. If your original question has been answered then please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.