Microsoft said it couldnt be done - Interactive Python Charts in Excel @MyOnlineTrainingHub
Microsoft said it couldnt be done - Interactive Python Charts in Excel  @MyOnlineTrainingHub
Uploaded August 2023 | Updated November 2026, 3 days ago
How to build interactive Python charts in Excel using Slicers to control interactivity and connected to data in Power Query.

With this trick we can use Slicers to control both Python charts and Excel charts at the same time. Suitable for Excel dashboards and more.


⬇️DOWNLOAD the Excel & CSV files here: myonlinetraininghub.com/interactive-python-charts-in-excel

📝 Note: Python in Excel is currently available to Microsoft 365 Office Insider users on the Beta Channel: insider.microsoft365.com/join

PQ Learn Power Query: myonlinetraininghub.com/excel-power-query-course

❓ Will you be using Python Charts in Excel? Please let me know in the COMMENTS.

🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

📢 Please leave me a COMMENT. I read them all!

🎯 CONNECT with me on LinkedIn: linkedin.com/in/myndatreacy

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum



⏲ TIMESTAMPS
0:00 Interactive Python Charts in Excel
0:28 Connect Python in Excel to Power Pivot
2:18 Create Python Dataframe
4:11 Setting up the Slicer
5:17 Capturing Selections in Slicer
6:33 Filtering the dataframe with Slicer
7:43 Creating the Python Chart in Excel
10:27 Create Pivot Chart Connected to Slicer
12:50 Limitations
Microsoft said it couldnt be done - Interactive Python Charts in ExcelExcel Slicer Custom Sorting Hacks - Masterclass!3 PivotTable Grouping Tricks to Summarize Data FAST!I dont use OFFSET Anymore! I Use Another Function Instead.The Excel Tool That Does What PivotTables Can’t (File Included)These SUM Tricks Will Blow Your Mind (No, Seriously)Excel PivotTables Made Easy in 2026 (+ Whats Changed!)Excel Techniques for 80/20 Data Analysis (Pareto Principle)Say Goodbye to Manual Calendars with This Excel Trick (File Included)STOP Writing Multiple Formulas When One Will DoExcel Just Made File Imports Ridiculously Simple (New Functions)From Negative to Positive Values in Excel | Beginner to Advanced
MyOnlineTrainingHub |

Microsoft said it couldn't be done - Interactive Python Charts in Excel

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER