Today, I’ll share my preferred approach for making dot plots using an XY scatterplot. As the old adage goes, “There are many paths to the top of the mountain, but the view is always the same.” You could make a dot plot in Excel out of a stacked bar chart, a line graph, or an XY scatterplot. There are multiple ways to go about this. It sounds like some sort of wizardry, yet hopefully, this article will take the magic out of the process, enabling you to build dot plots and other custom creations.
To build a dot plot in Excel, you need to get creative and format an existing chart to present as a dot plot. Unfortunately, many graphing tools don’t include dot plots in their default charting options-including Excel, my preferred graphing tool.
