New trick to connect any chart to a pivot table + awesome dynamic sunburst chart in Microsoft 365
New easy method to connect any chart to pivot table data specially for Microsoft 365 and an awesome interactive sunburst chart as an application example.
Pivot tables are very useful for analyzing data, but do not work with all chart types. In this video you will see how to connect any chart to a pivot table dynamically using a spill range. This solution is for Microsoft 365 desktop app and online. In the second part of the video you will also see a macro for collapsing/expanding selected slicer items (only for desktop app).
00:00 Intro
00:55 Preparing the pivot table
01:51 Preparing the spill range with function OFFSET
03:02 Adding the sunburst chart to the spill range
03:37 Important adjustment to the formula
04:36 Adding new data to the source table
05:02 Adding a pivot table slicer
05:38 Trick to add an extra button to the slicer
06:48 Change the slicer connection to another pivot table
08:22 Macro for expanding/collapsing the pivot table (ONLY for desktop app)
10:05 Testing the macro
11:11 Adapting the macro to your own file
For more contents like this, please subscribe to my channel.
#MsExcel #ExcelTips #VBA
Screenshots used with permission from Microsoft.
Some images on the thumbnail of this video are AI-generated using Canva.com.