Dot Plots In Excel

Dot plots in Excel is one of the methods to plot data using dots in Excel. It is not an inbuilt chart type but we can achieve it using simple steps.

Dot plots are commonly set up with one axis representing the range of values or categories along which the data points are categorized and a second axis representing the number of data points in each category. For easy visual comparison, dots can be stacked vertically or horizontally to display how many are in each group.

For example, consider the below table showing marks obtained by Allen in semester 1.

The same data can be converted into dot plots in Excel as shown in the below image.

Likewise, we can use dot plots in Excel.

Creating data plots in Excel is all about using Select Data Source window effectively. We use it to carefully select the cell range required for.

Let us learn how to use and apply dot plots in Excel with detailed examples.

Example #1

We have created one of the sample data item-wise sales numbers for five months; below is the same sample data. Next, we will create a dot plot for this Excel data.

Below is "Item 3."

We will have a "Dot Plot" chart ready like the below one.

As we can see, instead of the traditional “Column Bar Chart,”  we have a “Dot Plot Chart.”

Example #2

Consider the below table showing marks obtained by Billy in subjects, Physics, Chemistry and Biology in 3 different exams.

Now, let us use and apply dot plots for the data in Excel.

First, to start with, enter numbers 1, 2, and 3 in the next columns of the data as shown in the below image.

Now, select the first two rows of the data, i.e., rows A and B and insert the column chart in Excel.

Next, right-click on the chart. In the tab of options, click on “Select Data.” Now, we need to choose the “Edit” option.

The Edit Series window appears.

Here, we can see the existing values as our selected range. Now, we need to delete the Series values: and enter 0,0,0. Next, click on OK.

We can see a blank chart as shown in the below image.

Now, we have to right-click on the chart and choose "Select Data Source." Next, click on the "Add" button. In the appearing window, we need to select cell A1 for "Series name" and "Series values," and enter "1" as the value in the window.

Next, click on "OK." We will be able to see a chart as shown in the below image.

Next, we need to right-click on the chart and choose "Change Chart Type."

The window, Change Chart Type appears. In the window, we must select "Combo." Next, choose Scatter type chart next to option, Physics under the category – Choose the chart type and axis for your data series:

We will be able to see a chart as shown in the below image with just a dot. In simple terms, the column bar replaced with just a dot.

Finally, right-click on the chart and choose "Select Data" again. Here, select "Physics" and click on "Edit" in the next window.

The Edit Series window appears.

Now, we have to select Series name:, Series X values:, Series Y values: as shown in the below image.

Now, click "OK." We will have a dot plot chart for Physics.

We need to repeat the same process for data, "Chemistry."

Now, click "OK." We will have a dot plot chart for Physics.

We need to repeat the same process for data, "Biology."

Now, we can see dot plots in Excel for the given data.

Likewise, we can use dot plots in Excel.

• There is no built-in dot plot chart in Excel.
• We need a combination of the scattered chart to create a dot plot chart.
• We can increase the size of the dots in case required under the format data series section.
• If we need a horizontal dot plot chart, we need to insert a bar chart in excel instead of the column chart.