-
Book Overview & Buying
-
Table Of Contents
Python in Excel for Data Analytics
By :
In this chapter, you learned how to create a wide range of visualizations using seaborn inside Python in Excel. You started with the basics—creating simple charts, adding titles and labels, and understanding how seaborn and matplotlib work together. From there, you built histograms, box plots, scatterplots, strip plots, and pair plots to explore distributions and relationships in your data.
You also created correlation heatmaps to get a high-level view of how all numeric variables relate to one another and used regression plots to visualize linear trends. Finally, you explored small multiples with FacetGrid and learned practical techniques for managing chart output in the Excel grid.
Throughout the chapter, you saw a consistent pattern: seaborn handles the heavy lifting of creating statistical charts with minimal code, while matplotlib steps in for customization like titles, labels, and figure sizing. You also learned that the hue parameter is a versatile tool for adding...