Data visualization is a fundamental aspect of effective data analysis. And although Excel is a versatile tool, certain visualization types remain difficult or even impossible to create with its …
Python in Excel: Creating layered and faceted visualizations with Plotnine
In a previous post, we explored the plotnine package in Python in Excel, highlighting how its implementation of the Grammar of Graphics allows for an almost limitless array of possibilities in …
Continue Reading about Python in Excel: Creating layered and faceted visualizations with Plotnine →
Python in Excel: How to understand the plotnine package
Python in Excel offers powerful tools for creating impactful visualizations, and one standout option is the plotnine package. In this post, we'll delve into the origins and philosophy of plotnine, …
Continue Reading about Python in Excel: How to understand the plotnine package →
Python in Excel: How to understand the Seaborn package
Python’s integration into Excel has opened a new world of possibilities for data analysis and visualization, and Seaborn is one of the most exciting tools to leverage within this environment. Seaborn …
Continue Reading about Python in Excel: How to understand the Seaborn package →
How to create interactive scatterplots with Python in Excel
In an earlier post, I discussed adding conditional formatting to an Excel chart. One key benefit of using Python in Excel for this—rather than relying on standard Excel charting—is the flexibility it …
Continue Reading about How to create interactive scatterplots with Python in Excel →
How to conditionally format a scatterplot in Excel
A scatterplot is a chart that displays the relationship between two variables by plotting data points along the X and Y axes, with each point representing a unique pair of values. By conditionally …
Continue Reading about How to conditionally format a scatterplot in Excel →