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...
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.
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.
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.
Python Charts in Excel, Slicers in Excel, Excel Dashboards, Interactive Python Charts, Power Query, Power Pivot