excel for mac scatter plot x axis labels

Excel Scatter Plot X Axis Labels Series Directly Otherwise

Therefore, it is said that dot plots can be easier to understand than the conventional bar charts or histograms.

Dot plot allows viewing the relationship between two points more precisely than the bar charts as well as it is flexible in nature.

It can easily be read as well, which comprises a better understanding to the user.

Though there is no direct inclusion of dot plots under excel and its different versions, you still can have it done under Microsoft Excel with some amendments under conventional bar charts.

Though we have conventional scatter plots added under Excel, those can not be considered as dot plots.

Follow the below step to insert a column chart based on the first two rows.

There, click on Insert Column or Bar Chart dropdown bar and select Clustered Column chart under 2-D Column Chart section.

Excel Scatter Plot X Axis Labels Series Directly Otherwise

We cant remove the bars series directly otherwise our dot chart will get affected.

Therefore, what we will do is we set the series values for these bars as zero so that they are not visible under the chart.

It will open up a Select Data Source window where you can change the data source for Y-axis values a.k.a.

Legend Entries (Series) as well as X-axis categories a.k.a.

Horizontal (Category) Axis Labels.

This as discussed above will negate the column bars appearing on the chart.

However, we need to decide spacing for four years data as it is mandatory while we create the dot chart.

This spacing is nothing but the distance in units which allows the dot chart separate from each other.

This spacing can be changed as per your requirement and is totally up to you on how you decide this.

Right-click on graph area and choose Change Chart T y pe option.

Final chart layout should be like the screenshot below after adding the values for these years sales.

You can choose your custom colors while creating a one under format series options or design options.

We will see some points to be remembered with reference to the dot plot in Excel.

However, you can create this graph with the help of a combination of a simple bar chart and scatter chart.

Here we discuss How to create Dot Plots in Excel along with practical examples and downloadable excel template.

Excel For Mac Scatter Plot X Axis Labels