Home » Quality Improvement Charts » Dot Plot

Want to Create Dot Plots in Excel?

It's Easy with QI Macros Excel add-in!

Why It Matters: A dot plot is a type of frequency histogram that shows distribution of data. Use a dot plot or frequency histogram when you have a limited number of discrete values.

Example of a Dot Plot created using QI Macros

If your data has too many distinct values, your dot plot will look like the example below. Use a histogram on your data instead.

How to Create a Dot Plot in Excel using QI Macros

While its possible to create a dot plot in Excel, it is very time consuming and you have to know what all of the steps are. To save time, consider creating a dot plot using QI Macros add-in for Excel. Its super simple and takes just seconds.

1. Click and drag over your data to select it.
2. Then click on the QI Macros menu and select Box, Dot & Scatter then "Dot Plot":
   
   
3. QI Macros will perform all of the calculations and draw a dot plot for you.

Up your data analysis game. Use QI Macros to draw:

Other Reasons to Choose QI Macros add-in for Excel