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.
