Enhancing your Excel reports with plotnine2, matplotlib, and plotly graphs

The Python section of this chapter explores the integration of popular data visualization libraries, such as plotnine, matplotlib, and plotly, with Microsoft Excel using Python.

You’ll learn how to leverage the strengths of each library to visualize data effectively and enhance your Excel reports.

This part of the chapter is organized into the following sections:

• Enhancing Excel reports with visualizations: We’ll provide guidance on effectively using visualizations to communicate insights and patterns.
• Introduction to visualization libraries: We’ll provide an overview of the key visualization libraries – plotnine, matplotlib, and plotly. Understanding these and the use cases is essential for selecting the right library for your needs.
• Creating graphs with plotnine: This section will delve into using the plotnine library to craft sophisticated graphs. You’...