Excel
19 posts
When you have many categories, use ridgelines to create an extremely compact visualization where you can easily identify major patterns and outliers. They are especially useful to display surges in mostly flat data series. Become a member for access to this — plus tutorials, courses, and guides.
An alluvial diagram is a type of flow chart that is useful to show change over time. You see how individual categories and how the composition of the categories shift. Incorporate ranking into the mix at each time segment, and you get a good idea of how order changes over time too. The geometry is like a combination of a stacked bar chart and a bump chart. I made a...
Also known as trellis charts, lattice chart, or whatever you want to call them, the technique lets you compare several categories in one view. Read More
Marimekko charts, or mosaic plots, allow you to compare categories over two quantitative variables. Read More
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. Read More
Microsoft Excel is useful for many things, but it has its limitations (like all software), which led to an undercount of 15,841 Covid-19 positive tests recorded by Public Health England. For the Guardian, Alex Hern reports: In this case, the Guardian understands, one lab had sent its daily test report to PHE in the form of a CSV file – the simplest possible database format, just a list of values...
Heatmaps quickly translate data tables into a visual form, making them a great tool to explore a new dataset. Read More
Show current evolution against expected historical variability and add one or more series that could account for the difference. Read More
Dylan Tallchief recreated “Take On Me” by a-ha in Excel. It’s not the tools. It’s how you use them. Something something blah blah. It’s in Excel! Tags: a-ha, Excel, songs