Interactive Python Charts in Excel - Microsoft said it couldn't be done!
How to build interactive Python charts in Excel using Slicers to control interactivity and connected to data in Power Query.
Interactive Python Charts can be built in Excel, contrary to common belief! This breakthrough is achieved using Slicers, tied to data from Power Query. The resulting setup enables the control of both Python and Excel charts simultaneously. This innovative feature is ideal for use in Excel dashboards and other applications. Users can download the necessary Excel and CSV files from www.myonlinetraininghub.com/interactive...
- Python in Excel is currently accessible to Microsoft 365 Office Insider users who are in the Beta Channel at insider.microsoft365.com/join
- A course in Power Query is available at www.myonlinetraininghub.com/excel-power...
- Feedback and queries related to Python Charts in Excel are welcome in the COMMENTS section.
- For more tutorials and tips, users are invited to SUBSCRIBE.
- Users can also connect with the author on LinkedIn at www.linkedin.com/in/myndatreacy/
- Excel-related questions can be addressed at the dedicated Excel Forum: www.myonlinetraininghub.com/excel-forum
The procedure involves connecting Python in Excel to Power Pivot, creating a Python Dataframe, setting up the Slicer, capturing selections in Slicer, filtering the dataframe with Slicer, and finally creating the Python Chart in Excel. A Pivot Chart connected to the Slicer is created towards the end, and some limitations of this setup are also cited.
Further Discussion on Interactive Python Charts in Excel
In a significant innovation, Microsoft has enabled the creation and control of interactive Python charts in Excel. This development opens new possibilities for data visualization and manipulation directly in Excel, with the control made possible by using Slicers tied to data in Power Query. By using Python in Excel, users get the power of a powerful programming language within the familiarity of Excel, while still retaining Excel's interaction capabilities. They can now create more advanced and complex dashboards and explore data in new ways.
Learn about Interactive Python Charts in Excel - Microsoft said it couldn't be done!
With this trick, you can use Slicers to control both Python charts and Excel charts at the same time. You can connect Python in Excel to Power Pivot, create a Python Dataframe, set up the Slicer, capture selections in the Slicer, filter the dataframe with the Slicer, create Python charts in Excel, create Pivot Charts connected to the Slicer, and more. Learn how to use this trick to build interactive Python charts in Excel and create Excel dashboards.
Microsoft 365 Office Insider users can use Python in Excel on the Beta Channel. Learn more in my Excel courses, and get help on the Excel Forum.
You can download the Excel and CSV files, subscribe for more tips and tutorials, connect with me on LinkedIn, and share this video to spread the Excel love.
More links on about Interactive Python Charts in Excel - Microsoft said it couldn't be done!
- Mynda Treacy's Post - excel #python #microsoftambassador
- Microsoft said it couldn't be done! ... build interactive dashboards containing both Python and Excel charts side by side, controlled by the same Slicers.
- Suddenly don't have access to charts (grayed out)
- Jun 20, 2020 — I have owned MS Office (not 365) for a few years and I had been charting my financial data that I enter into an Excel spreadsheet each week.
- Microsoft Office document is "locked for editing by 'another ...
- Aug 27, 2009 — I've seen this error today, when another user genuinely did have the file open. The problem was that Excel tells the second user that it's ...
Keywords
Python Charts in Excel, Slicers in Excel, Excel Dashboards, Interactive Python Charts, Power Query, Power Pivot