Pivot Chart issues after saving

[JoshuaDoherty92]

Good Morning,

First time poster here, I've started using excel again at work for the first time in 6 years so my apologies if this has an easy solution.

I'm having trouble with my pivot chart. I'm creating a pivot chart and when I first create the chart I'm having absolutely no issues with operating it. However, when i save it, close the book and then re-open the pivot-chart stops working.

When I open the book and try and change the filter on the corresponding pivot table to the chart, the pivot table changes, but the pivot chart stays exactly the same. So if i want to filter one particular pupil (this is a school report) for my chart, I can't.

I should add that when I open the book and first try to operate the filter I'm greeted with "The Pivot table report was saved without the underlying data, use the refresh data command to update the report." I update this and the pivot table can then be used and the filters can be operated, but the chart doesn't change at all. I've attached an image below to help make sense. This is all fake data to test the document which is why data is appearing for the next 3 weeks.

Thanks in advance for any help.

Kind Regards

 

[GlennUK]

Can I ask whether you are keeping the source and PivotTable/PivotChart in separate workbooks? And, if so, why?