How to Make Dot Plots in Excel? (Step by Step)

I have created one of the sample data item-wise sales numbers for five months; below is the sample data of the same. We will create a Dot Plot for this excel data. Follow the below steps:

Follow the below steps:

Enter numbers 1, 2, and 3 in the next columns of the data. Refer below image.
Now select the first two rows of the data and insert the column chart in excel.
Now right-click on the chart and choose “Select Data”.
In the below dialogue box, choose the “Edit” option.
We can see the existing values as our selected range.
Delete these existing values and enter 0, 0, 0 for all the three items.
Click on the Ok, we will have a blank chart like the below one.
Again, right-click on the chart and choose “Select Data”. In the below window, click on the “Add” button.
In the below window, select the cell A1 for “Series Name” and for “Series Values”, enter 1 as the value.
Click on the Ok, we will have a chart like the below one.
Now right-click on the chart and choose “Change Chart Type”.
In the below window, select “Combo”.
For “Item 1”, choose “Scattered Chart” and click on the Ok.
Now, we will have a chart like the below with just a dot, column bar replaced with just a dot.
Right-click on the chart and choose “Select Data” again. In the next window, select “Item 1” and click on “Edit”.
Now, we can see below the options window.
For “Series Name”, choose cell A1, for “Series X Values”, choose the column which has number 1 (the one we have entered manually in step 1), and for “Series Y Values”, choose Item 1 numbers.
Click on the Ok, now we will have a dot plot chart for “Item 1”.
Now we need to repeat the same process for the other two items, i.e., “Item 2” and “Item 3”.
Below is for Item 2.