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.
Displaying expected versus actual values is a common task in data visualization, and multiple levels of detail and complexity can be used. The chart below lets you compare a reference line to current data and see how they change over time. It includes several subtasks, like displaying expected variability, absolute differences and the data for a major component of that difference.
To access this full tutorial and download the source code you must be a member. (If you are already a member, log in here.)
Get instant access to this tutorial and over a hundred more, plus courses, guides, and additional resources.
You'll get unlimited access to hundreds of hours worth of step-by-step visualization courses and tutorials for insight and presentation — all while supporting an independent site. Source code and data is included so that you can more easily apply what you learn in your own work.
The tutorials are very helpful to move from "Oooo, cool!" to how to actually DO the cool.
Members also recieve a weekly newsletter, The Process. Keep up-to-date on visualization tools, the rules, and the guidelines and how they all work together in practice.
See samples of everything you gain access to:
More Tutorials See All →
How to Make Smoothed Density Maps in R
Too many points to plot often means obscured patterns in the clutter. Density maps offer a smooth alternative.
Drawing Squares and Rectangles in R
R makes it easy to add squares and rectangles to your plots, but it gets a little tricky when you have a bunch to draw at once. The key is to break it down to the elements.
How to Make Animated (GIF) Heatmaps in R
Using color as the visual encoding, show changes over time in two dimensions.