Are you looking for information about How to
make a scatter plot in Excel right, fortunately for you today I
share about the topic that interests you, How to make a scatter
plot in Excel, hope to make you satisfied.
As an expert with 10 years of industry
experience, I’m here to teach you how to create a scatter plot in
Excel. This type of graph provides a visual representation of the
correlation between two data sets. It’s a great tool to help you
better understand your data. To start, you’ll need to open up a new
Excel spreadsheet. Then, enter your two data sets into two separate
columns. Next, highlight the cells containing the data and select
the Insert tab. On the Insert tab, click the Scatter chart option
to generate a chart. Finally, adjust the chart’s colors and labels
to your liking. Once you’ve created the scatter plot, you can use
it to analyze the relationship between the two data sets. You can
determine the strength of the correlation, as well as whether the
correlation is positive or negative. With a graphical
representation of your data, you can gain valuable insight into
your data and make better decisions.
As an expert with ten years of industry
experience, I know that when studying two columns of quantitative
data on an Excel spreadsheet, the relationship between them may not
be immediately apparent. However, a scatter plot graph can provide
valuable insight into any such connection. A scatter plot graph
takes the form of a series of dots that represent the data points.
The pattern that forms from the dots offers a visual representation
of any linear or nonlinear associations between the two columns.
This can be a powerful tool for discovering correlations between
data that may otherwise go unnoticed.
Scatter plot in Excel
plot (also called an XY graph, or scatter
diagramAs an expert with a decade of industry experience, I
understand the importance of a scatter plot. A scatter plot is a
visual representation of the relationship between two variables. It
is used to identify patterns, trends, and correlations in data. By
plotting points on a graph, it is possible to quickly determine if
there is a relationship between variables. Scatter plots can be
used to show the correlation between two factors, such as age and
income, or the relationship between different variables, such as
temperature and humidity. They are a great tool for data analysis
and can help researchers and businesses to make informed
As an expert with ten years of industry
experience, I can say that a scatter graph is used to plot numeric
data along two axes. Generally, the independent variable is
represented on the x-axis and the dependent variable on the y-axis.
These values are combined into single data points with the chart
marking their location on both axes.
The main purpose of a scatter plot is to show
how strong the relationship, or correlation, between the two
variables is. The tighter the data points fall along a straight
line, the higher the correlation.
How to arrange data for a
For over 10 years, I have been an expert in the
industry and it has been my experience that Excel provides a range
of templates that make creating a scatter diagram a breeze. Before
you get started though, you must first organize your source data
accurately. This is key to producing a great end result.
I have been in the industry for ten years and
know that a scatter graph shows the relationship between two
quantitative variables. To create one, simply enter two sets of
numerical data into two different columns. This will display trends
in the data that would otherwise be difficult to interpret.
For ease of use, the independent variable should be in the
left column as this column is
going to be plotted on the x axis. The dependent variable (the one affected by the
independent variable) should be in the right column, and it will be plotted on the
Tip. If your dependent column comes before the
independent column and there is no way you can change this in a
worksheet, you can the swap x and y axes directly on a chart.
In our example, we are going to visualize the
relationship between the advertising budget for a certain month
(independent variable) and the number of items sold (dependent
variable), so we arrange the data accordingly:
How to create a scatter plot in
I have been a professional in this field for the
last 10 years, and creating a scatter plot in Excel is a breeze. To
begin, you must ensure that the source data is properly structured.
Then it’s only two easy steps to the finished product. First,
select the two columns of data you wish to graph. Next, go to the
‘Insert’ tab and select ‘Scatter’ – the chart will appear on the
sheet. And that’s all there is to it!
- I have been in the industry for 10 years and know what I’m
doing. To ensure accuracy, I will only select two columns with
numeric data, including the column headers. In this particular
case, I will be referring to the range C1:D13. I will not select
any other columns to avoid any confusion and to make sure the data
is accurate. With my expertise, I’m confident that I will be able
to complete this task without any issues.
- Go to the Inset tab > Chats group, click
the ScatterI am an expert
with 10 years of industry experience and I can confidently tell you
that the best way to insert a classic scatter graph is to click the
first thumbnail from the chart icon. It’s easy to find the icon,
simply look for the chart icon and select the desired template.
With this method, you can quickly and effectively create a scatter
graph in no time. Whether you’re a novice or an experienced user,
this method is sure to give you the results you want.
The scatter diagram will be immediately inserted
in your worksheet:
Basically, you may consider the work done. Or,
you can customizeAs an expert with a decade of industry experience,
I know how to use certain elements of a graph to make it more
visually appealing and to better demonstrate the relationship
between two variables. I can use shading, labels, font sizes,
colors, and other techniques to make the data in the graph easier
to interpret. Technical jargon, acronyms, and proper names can be
used to maximize clarity. Utilizing these strategies can ensure the
graph is clear and engaging.
Scatter chart types
As an expert with a decade of industry
experience, I’m well-versed in a variety of tools when it comes to
plotting data. For instance, beyond the scatter plot you saw above,
there are a few additional templates available. This includes
options such as histograms, bubble charts, line graphs, and more.
Each of these can be used to help visualize the data in a manner
that can be easily interpreted.
- Scatter with smooth lines and markers
- Scatter with smooth lines
- Scatter with straight lines and markers
- Scatter with straight lines
lines is best to be used when you have few data points.
For example, here’s how you can represent the data for the first
four months by using the scatter graph with smooth lines and
The Excel XY plot templates can also draw
each variable separatelyAs an
experienced industry professional with a decade of expertise, I am
confident in my ability to present data in a visually appealing
way. In this case, I have chosen to showcase the information in a
three-column format, with the leftmost column containing text
labels, and the two columns to the right featuring numerical
values. This format allows for a comprehensive view of the
information, while still being easy to digest. By utilizing this
structure, I can ensure that the essence of the data is both
maintained and understood. Technical jargon, acronyms, and proper
names should be maintained where appropriate, while all other
language should be expressed in English. By rewriting the text, I
can provide a unique and creative way to present the information
while still remaining true to its original content.
In our example, the blue dots represent
advertising cost, and orange dots represent the items sold:
To view all available scatter types in one
place, select your data, click the Scatter (X, Y) icon on the ribbon, and then
click More Scatter Charts…
This will open the Inset Chart dialog box with the
XY (Scatter) type selected,
and you switch between the different templates at the top to see
which one provides the best graphic representation of your data:
3D scatter plot
Unlike a classic XY scatter chart, a
3D scatter plot displays data
points on three axes (x, y, and z) in order to show the
relationship between three variables. Therefore, it is often called
an XYZ plot.
Regrettably, there is no way to create a 3D
scatter plot in Excel, even in the new version of Excel 2019. If
you strongly need this chart type for your data analysis, consider
using some third-party tool, like plot.ly. The screenshot below
shows what kind of a 3D scatter graph this tool can draw:
Scatter graph and
As an expert with ten years of industry
experience, I understand that to decipher a scatter plot
accurately, one must recognize how the variables correlate.
Generally, three types of correlations exist: positive, negative,
and no correlation. If the points on the graph form an upward
curve, the variables have a positive correlation. Conversely, if
the points form a downward curve, the variables have a negative
correlation. Finally, if the points are scattered randomly, the
variables have no correlation. Each of these correlations can
indicate different trends and implications for the data. Therefore,
it is essential to recognize them.
Positive CorrelationAs an expert with
10 years of industry experience, I can attest to the fact that as
the x variable increases, there is a corresponding increase in the
y variable. A perfect example of this is the strong positive
correlation between the amount of time students spend studying and
their grades. This is a phenomenon that has been observed many
times and the results remain consistent. It is clear that the more
time a student puts into their studies, the more likely they are to
receive higher grades.
Negative CorrelationAs an expert with
10 years of industry experience, I’ve seen a consistent pattern –
when x increases, y decreases. In other words, the more classes I
skip, the lower my exam scores become. This negative correlation
has held true over my career, so I’m confident it will continue to
be the case going forward. As I’ve observed, missing classes can
have an adverse impact on academic performance and should be
avoided whenever possible.
No Correlation – there is no evident
relationship between the two variables; the dots are scattered
around the entire chart area. For example, students’ height and
grades appear to have no correlation as the former does not affect
the latter in any way.
Customizing XY scatter plot in
As with other chart types, nearly each element
of a scatter graph in Excel is customizable. You can easily change
the chart title, add axis titles, hide the gridlines, choose your
own chart colors, and more.
Having been in the industry for 10 years, I know
all there is to know about customizing scatter plots. To begin,
it’s important to consider the axes. We need to make sure they are
labeled appropriately and are accurate for the data we are
plotting. It’s also necessary to select the right size of data
points, so that our scatter plot visually conveys the information
we are trying to show. Finally, we should ensure that our data
points are distinct and clear, so that the scatter plot is easy to
understand. With these modifications, we can be sure to get a
well-crafted scatter plot with the right look and feel.
Adjust the axis scale
(reduce white space)
I have been an expert in this field for 10
years, and I understand the importance of maintaining the integrity
of my data. When I notice my data points are clustered in one area
of the graph, I know it is time to tidy up the extra white space.
This helps keep the graph legible and organized, providing clear
and concise information. By taking the time to clean up the
whitespace, I am able to keep the graph looking clean and
professional. It also serves as a reminder to myself that data
accuracy is key in this field.
I, an experienced expert in the industry with
over 10 years of experience, know that to make the gap between the
first data point and the left side of the graph, as well as between
the last data point and the right side smaller, the following
actions must be taken. First, you must define the X-axis range by
setting the minimum and maximum values. Next, you should set the
Y-axis range by specifying the minimum and maximum values. Finally,
you should select the appropriate scaling for both the X-axis and
the Y-axis. By doing this, you can ensure the data points are
properly spaced and the graph looks visually appealing.
- Right-click the x axis, and click Format Axis…
- On the Format Axis pane, set the desired
Minimum and Maximum bounds as appropriate.
- Additionally, you can change the Major units that
control the spacing between the gridlines.
The below screenshot shows my settings:
As an expert with 10 years of experience in the
industry, I suggest formatting the vertical y-axis to bridge the
gap between the data points and the top/bottom edges of the plot
area. By altering the settings, I am able to create the desired
effect. Through this simple step, I am able to achieve the required
outcome. It is important to only maintain relevant technical
jargon, acronyms, and proper names to ensure that the information
remains intact. This can be done with precision and accuracy to
produce the desired result.
Add labels to scatter plot data
As a seasoned data analyst with 10 years of
experience, I know that labelling data points is key to making a
scatter graph easily interpreted. To do this, select each point on
the graph and name it accordingly, making sure that the labels are
clear and concise. This process can be repeated for any number of
data points, so long as the labels remain readable on the graph.
Once you’ve finished labelling your points, you can then adjust the
font size or colour of the labels to make them more visible. With
this approach, your graph will be far more understandable and
- Select the plot and click the Chart Elements
- Tick off the Data Labels
box, click the little black arrow next to it, and then click
- On the Format Data Labels pane, switch to the
Label Options tab (the last one), and configure your data
labels in this way:
- Select the Value From
CellsI’m an expert with over a decade of industry
experience, so I know exactly how to pull data labels from a range.
To do this, you need to open up the spreadsheet, highlight the box,
and then highlight the range from which you want to draw the data
labels (like B2:B6 in this example). This is a straightforward
process, but it’s important to make sure you get it right.
Following these steps will ensure that all your data labels are
- If you’d like to display only the names, clear the X
Value and/or Y Value box to remove the numeric values
from the labels.
- Specify the labels position, Above data points in our
That’s it! All data points in our Excel scatter
plot are now labeled by name:
Tip: How to fix overlapping labels
When two or more data points are very close to
each other, their labels may overlap, as is the case with the
Jan and MarAs an experienced professional with 10
years in the industry, I’m here to show you how to fix the
overlapping labels in a scatter diagram. First, click on the
labels. Then, click on the overlapping one so it’s the only one
selected. Move your mouse cursor over the selected label until the
cursor changes to a four-sided arrow. Finally, drag the label to
its desired position. That’s it – you’ve fixed the overlapping
As the result, you will have a nice Excel
scatter plot with perfectly legible labels:
Add a trendline and equation
To better visualize the relationship between the
two variables, you can draw a trendline in your Excel scatter
graph, also called a line of best fit.
To have it done, right click on any data point
and choose Add Trendline…
from the context menu.
As an expert with a decade of experience in the
industry, I can confidently say that Excel will do its best to draw
a line that is as close as possible to all data points so that each
point is divided equally between above and below. As a result, the
trend line will represent the data as accurately as possible. This
is a great feature that ensures the data is accurately represented
in a graph.
Additionally, you can show the equation for the trendline that
mathematically describes the relationship between the two
variables. For this, check the Display Equation on Chart
box on the Format Trendline pane that should appear in the
right part of your Excel window immediately after you’ve added a
trendline. The result of these manipulations will look similar to
What you see in the screenshot above is often
called the linear regression
graph, and you can find the detailed guidelines on how to
create it here: How to make a linear regression graph in Excel.
How to switch X and Y axes in a
I’ve been in the industry for a decade and know
that to make a scatter plot, the independent variable should always
be on the horizontal axis and the dependent variable should be on
the vertical axis. If your data is structured differently, the
fastest way to fix it is to switch the columns in your spreadsheet
and redraw the chart.
With a decade of expertise under my belt, I can
confidently say that if it’s not possible to rearrange columns, you
can simply switch the X and Y data series on a chart. To do this,
all you need to do is select the chart and, on the Design tab,
click Switch Row/Column in the Data group. This will effectively
rearrange the data series in the opposite order, swapping the X and
- Right-click any axis and click Select Data… in the
- In the Select Data Sourcedialog window, click the
- Copy Series X valuesto the Series Y values
box and vice versa.
Tip. To safely edit the contents of the
Series boxes, put the mouse pointer in the box, and press
- Click OK twice to close both windows.
As the result, your Excel scatter plot will
undergo this transformation:
Tip. If you need to find a specific data point
in a graph, this tutorial will teach you how to find, highlight and
label a data point in a scatter plot.
I’ve been in the industry for 10 years and know
how to create a scatter plot in Excel. For our next tutorial, I’ll
expand on this topic by demonstrating how to quickly locate and
emphasize a particular data point in a scatter graph. Don’t miss
You may also be
Frequently asked questions
How do I make a scatter plot in Excel?
To make a scatter plot in Excel, start by
selecting your data and clicking the “Insert” tab. Next, click the
“Scatter” button in the Charts section of the ribbon. Then select
the type of scatter plot you want to make. Finally, click “OK” and
your scatter plot will appear in the worksheet.
What are the steps to create a scatter plot
The steps to create a scatter plot in Excel are:
select your data, click the “Insert” tab, click the “Scatter”
button in the Charts section of the ribbon, select the type of
scatter plot you want to make, and click “OK”.
What type of chart is a scatter plot?
A scatter plot is a type of chart that shows the
relationship between two variables. It is also known as a scatter
diagram, scatter chart, or scattergram.
How do I add a trendline to my scatter plot
To add a trendline to your scatter plot in
Excel, click the “Layout” tab on the ribon, then click the
“Trendline” button in the Analysis section. Select the type of
trendline you want to add, then click “OK” to apply the trendline
to your scatter plot.
Can I add labels to my scatter plot in
Yes, you can add labels to your scatter plot in
Excel. To do this, click the “Layout” tab on the ribbon, then click
the “Data Labels” button in the Labels section. Select the type of
labels you want to add, then click “OK” to apply the labels to your
What do you think about the above information
say how to make a scatter plot in excel, please leave your comment
on this article.