How to Make a Multi-Series Dot Plot in Excel
Easily compare multiple categories and spot differences between two or more series.
Similar to a standard bar chart, you can use dot plots to compare categories. However, dot plots offer some advantages with certain data sets. If you are using more than one series, it’s easier to spot the differences between them, because dots use less visual space than bars. Also, it’s often (strongly) suggested that, when using bar charts, we should start the scale at zero, because they can be misleading if the scale starts at a different point. With dot plots it’s easier to compare relative positions, so you don’t have to start the scale at zero.
In this tutorial, you will learn how to make a dot plot with two series in Excel. It is not available as a default Excel chart but, with a few tweaks, you can easily turn one of the available charts into a dot plot.
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 Maps in R That Include Alaska and Hawaii
The conterminous United States always gets the attention, while Alaska and Hawaii are often left out. It is time to bring them back into view.
How to Make Bubble Charts
Ever since Hans Rosling presented a motion chart to tell his story of the wealth and health of nations, there has been an affinity for proportional bubbles on an x-y axis. This tutorial is for the static version of the motion chart: the bubble chart.
Detecting and Plotting Sequence Changes
Change detection for a time series can be tricky, but guess what, there’s an R package for that. Then show the results in a custom plot.