Forum Discussion
PRSharry
May 27, 2022Copper Contributor
Connecting Multiple Pivot Charts to Single Timeline - Solved
Hi All *********************************** Surface Book /Windows 11 Home Microsoft® Excel® for Microsoft 365 MSO (Version 2204 Build 16.0.15128.20240) 64-bit ************************************...
- May 27, 2022
PRSharry Otherwise try by copying a PT that does connect to the timeline and then modify it. Than you are certain that the tables/charts share the same pivot cache.
Riny_van_Eekelen
May 27, 2022Platinum Contributor
PRSharry Is the 6th chart using the same data source as the others? If not, you can't connect all with one time-line.
- PRSharryMay 27, 2022Copper ContributorHi Riny
That's a good place to start, thanks. I'm sure I built all the pivot tables from the same data Table where my primary data is, but will check. I only have one worksheet connection showing in my Queries and Connections list.
Cheers
Peter- Riny_van_EekelenMay 27, 2022Platinum Contributor
PRSharry Otherwise try by copying a PT that does connect to the timeline and then modify it. Than you are certain that the tables/charts share the same pivot cache.
- PRSharryMay 27, 2022Copper ContributorHi Riny
Nice - sometimes the simple solutions are the best. I copied a tab with PT that links to the Timeline and the new parameter links too. Should have thought of that myself !. Thanks so much.
Regards
Peter