How to Create a Scatter Plot In Excel
With the source data correctly organized, making a scatter plot in Excel takes these two quick sets:
- Select two columns with numeric data, including the column headers.
- Go to the Insert tab > Charts group, click the scatter chat icon, and select the desired template. To insert a classic scatter graph, click the first thumbnail:
Step 1: Formatting data for Scatter Plot. We have to make sure that there should be two variables for a set of data.
Step 2: Converting data into Scatter Plot. First, highlight the data which we want in the scatter plot.
Step 3: Click on the Insert tab on the Ribbon. In the Charts group, click Insert Scatter(X, Y) or Bubble Chart.
Step 4: In the resulting menu, click Scatter.
Once we have clicked that, our Scatter Plot will appear.
Step 5: Now, to add a label on the x-axis and y-axis we have to click on the Design tab on the Ribbon. In the Chart Layouts group, click Quick Layout.
Step 6: In the resulting menu, click Layout 1.
Step 7: Then change the label name of the X axis from Axis Title to Year and the Y axis from Axis Title to Population.
How to Create a Scatter Plot In Excel?
A scatter plot is a mathematical diagram made using the Cartesian coordinates which are used to display typically 2D-data sets. These are also known as scatterplots, scatter graphs, scatter charts, scattergrams, or scatter diagrams.
In this article, we will look into how we can create scatter plots in Excel. To do so follow the below steps:
Contact Us