Also known as trellis charts, lattice chart, or whatever you want to call them, the technique lets you compare several categories in one view.
Excel
-
Members Only
How to Make Small Multiples in Excel
-
Members Only
How to Make Marimekko Charts in Excel
Marimekko charts, or mosaic plots, allow you to compare categories over two quantitative variables.
-
Members Only
The Process 111 – Excel Limit
A row limit in Microsoft Excel led to an undercount of Covid-19 cases in the thousands. The root of the problem goes past the software though.
-
Excel spreadsheet limit leads to 16,000 Covid-19 cases left off daily count
Microsoft Excel is useful for many things, but it has its limitations (like…
-
Members Only
How to Make a Heatmap in Excel
Heatmaps quickly translate data tables into a visual form, making them a great tool to explore a new dataset.
-
Members Only
How to Make a Customized Excess Mortality Chart in Excel
Show current evolution against expected historical variability and add one or more series that could account for the difference.
-
“Take On Me” by a-ha recreated in Excel
Dylan Tallchief recreated “Take On Me” by a-ha in Excel.
It’s not the… -
Members Only
How to Make Difference Charts in Excel
Also known as a bivariate area chart, the plot type focuses on the comparison between two time series.
-
Making stupid Excel bar charts
I’m just gonna put this right here, from @_daviant: “Another day another stupid…
-
Members Only
How to Make a Dynamic Multi-population Pyramid in Excel
Create better population pyramids that allow for improved comparisons between sexes and populations.
-
Members Only
How to Make a Multi-Series Dot Plot in Excel
Easily compare multiple categories and spot differences between two or more series.
-
Cleaning your data with Excel and Google Spreadsheets
For Datawrapper, Lisa Charlotte Rost outlines the steps to prepare and clean your…
-
R data structures for Excel users
Introducing yourself to R as an Excel user can be tricky, especially when…
-
Microsoft Excel painter
Remember the artist Tatsuo Horiuchi who uses Microsoft Excel to paint scenery? Four…
-
Data distributed as clipart
Government data isn’t always the easiest to use with computers. Maybe it’s in…
-
R for Excel users
For Excel users getting started with R, pain oftentimes finds its way into…
-
Excel heat map hack
John Nelson from IDV Solutions explains how he uses a Microsoft Excel hack…
-
Spreadsheets for life
Planet Money goes back to a 1984 article by Steven Levy that discusses…
-
Excel paintings
Tatsuo Horiuchi wanted to learn something new before retiring, so he bought a…
-
Five years of traffic fatalities
I made a graphic a while back that showed traffic fatalities over a…
