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.
Regular line charts display patterns and trends over time. Instead of comparing those trends, you may want to emphasize the gap between two series and the sections where they intersect and flip. That is what bivariate area charts are used for. A well-known historical example of a bivariate area chart is William Playfair’s trade balance chart.
In Excel, you can create a bivariate area chart with a combination of area and line chart. To illustrate this chart we’ll use a popular dataset, food availability in the US, and specifically the evolution of beef and chicken availability. We want to focus on the flip in recent years, when chicken surpassed beef.
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 Use IPUMS Extraction Tools to Download Survey Data
Almost all of my visualization projects that use data from the Census Bureau comes via IPUMS. In this guide, I provide five steps to getting the data you need using their tools.
How to Make Better-Looking, More Readable Charts in R
Defaults are generalized settings to work with many datasets. This is fine for analysis, but data graphics for presentation benefit from context-specific design.
How to Make Variable Width Bar Charts in R
The code to create these bar chart variations is almost the same as if you were to make a standard bar chart. But make sure you get the math right.