Here’s how to do it in R from start to finish, plus editing in illustration software. Make design choices and trade-offs for more readable charts.
Excel
-
Members Only
How to Make Alluvial Diagrams
-
Members Only
How to Make Small Multiples in Excel
Also known as trellis charts, lattice chart, or whatever you want to call them, the technique lets you compare several categories in one view.
-
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…
