Forum Discussion
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
******************************************
I'm creating a dashboard for some scientific data. I've created six Pivot Tables and Pivot Charts in separate worksheets in the same workbook. I've been able to create timelines for each pivot chart on the separate worksheets for each pivot table. They all work fine individually.
I want to adjust the displayed date range for all the pivot charts on the dashboard using one timeline - I've only been able to link 5 of the 6 pivot charts to the timeline - the last one doesn't appear on the list when I select Timeline / Report Connections.
Is there a limit of number of Report Connections to a timeline?
Is there something else I can check?
The spreadsheet is client data so I prefer not to send it for now, but if needed I will send a sanitised version.
Cheers
Peter
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.
4 Replies
PRSharry Is the 6th chart using the same data source as the others? If not, you can't connect all with one time-line.
- Hi 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
PeterPRSharry 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.
