Excel

19 posts
✚ How to Make Frequency Trails in Excel

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.

0 0
✚ How to Make Alluvial Diagrams

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...

0 0
✚ 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. Read More

0 0
✚ How to make Marimekko Charts in Excel

Marimekko charts, or mosaic plots, allow you to compare categories over two quantitative variables. Read More

0 0
✚ 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. Read More

0 0
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 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...

0 0
✚ 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. Read More

0 0
✚ 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. Read More

0 0
“Take On Me” by a-ha recreated in Excel

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

0 0
✚ 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. Read More

0 0