Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
58
Views
Topic starter
Hi so i have used power query to filter, sort my data into a pivot chart.
I now want to use that data against other data in a separate excel file. How do is put a link in to the pivot chart? i saw this on one of the lessons and can't find it. So for example linking the total column on my pivot chart to a separate excel spreadsheet.
Hope that makes sense?
Posted : 27/06/2023 11:26 am
Hi Ruth,
I would avoid links to external workbooks. Instead, use Power Query to bring the data into the file containing the Pivot Chart.
Regarding displaying total columns in Pivot Charts, see this tutorial.
Mynda
Posted : 27/06/2023 7:25 pm
