Jase Alexander
asked on
Excel Pivot table - Data for new year wont update in Pivot Chart?
HI Experts
Hope you can help
I have a basic pivot table / chart containing 2017 data for each month and it has been working fine up until entering this months’ data
There are two tabs – Pivot Table and Pivot Graph containing the raw and visual data, respectively.
When I refresh the data the slicers or graph won’t recognise 2018 data?
I’ve tried re-formatting and re-assigning the data entries but cannot get the 2018 data to appear via the filters.
I’ve attached the file - Would you guys have any suggestions as I’m stumped
Much appreciated as always
J
Summary_Utilisation_2017---Copy.xlsx
Hope you can help
I have a basic pivot table / chart containing 2017 data for each month and it has been working fine up until entering this months’ data
There are two tabs – Pivot Table and Pivot Graph containing the raw and visual data, respectively.
When I refresh the data the slicers or graph won’t recognise 2018 data?
I’ve tried re-formatting and re-assigning the data entries but cannot get the 2018 data to appear via the filters.
I’ve attached the file - Would you guys have any suggestions as I’m stumped
Much appreciated as always
J
Summary_Utilisation_2017---Copy.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No problem. Glad I could help.
ASKER
Wow thank you so much for your help
Its pefect