www.ablebits.com
Open in
urlscan Pro
54.165.213.88
Public Scan
URL:
https://www.ablebits.com/office-addins-blog/make-scatter-plot-excel/
Submission: On June 27 via manual from US — Scanned from DE
Submission: On June 27 via manual from US — Scanned from DE
Form analysis 8 forms found in the DOM
<form>
<fieldset>
<legend class="visuallyhidden">Consent Selection</legend>
<div id="CybotCookiebotDialogBodyFieldsetInnerContainer">
<div class="CybotCookiebotDialogBodyLevelButtonWrapper"><label class="CybotCookiebotDialogBodyLevelButtonLabel" for="CybotCookiebotDialogBodyLevelButtonNecessary"><span
class="CybotCookiebotDialogBodyLevelButtonDescription">Necessary</span></label>
<div class="CybotCookiebotDialogBodyLevelButtonSliderWrapper CybotCookiebotDialogBodyLevelButtonSliderWrapperDisabled"><input type="checkbox" id="CybotCookiebotDialogBodyLevelButtonNecessary"
class="CybotCookiebotDialogBodyLevelButton CybotCookiebotDialogBodyLevelButtonDisabled" disabled="disabled" checked="checked"> <span class="CybotCookiebotDialogBodyLevelButtonSlider"></span></div>
</div>
<div class="CybotCookiebotDialogBodyLevelButtonWrapper"><label class="CybotCookiebotDialogBodyLevelButtonLabel" for="CybotCookiebotDialogBodyLevelButtonPreferences"><span
class="CybotCookiebotDialogBodyLevelButtonDescription">Preferences</span></label>
<div class="CybotCookiebotDialogBodyLevelButtonSliderWrapper"><input type="checkbox" id="CybotCookiebotDialogBodyLevelButtonPreferences" class="CybotCookiebotDialogBodyLevelButton CybotCookiebotDialogBodyLevelConsentCheckbox"
data-target="CybotCookiebotDialogBodyLevelButtonPreferencesInline" checked="checked" tabindex="0"> <span class="CybotCookiebotDialogBodyLevelButtonSlider"></span></div>
</div>
<div class="CybotCookiebotDialogBodyLevelButtonWrapper"><label class="CybotCookiebotDialogBodyLevelButtonLabel" for="CybotCookiebotDialogBodyLevelButtonStatistics"><span
class="CybotCookiebotDialogBodyLevelButtonDescription">Statistics</span></label>
<div class="CybotCookiebotDialogBodyLevelButtonSliderWrapper"><input type="checkbox" id="CybotCookiebotDialogBodyLevelButtonStatistics" class="CybotCookiebotDialogBodyLevelButton CybotCookiebotDialogBodyLevelConsentCheckbox"
data-target="CybotCookiebotDialogBodyLevelButtonStatisticsInline" checked="checked" tabindex="0"> <span class="CybotCookiebotDialogBodyLevelButtonSlider"></span></div>
</div>
<div class="CybotCookiebotDialogBodyLevelButtonWrapper"><label class="CybotCookiebotDialogBodyLevelButtonLabel" for="CybotCookiebotDialogBodyLevelButtonMarketing"><span
class="CybotCookiebotDialogBodyLevelButtonDescription">Marketing</span></label>
<div class="CybotCookiebotDialogBodyLevelButtonSliderWrapper"><input type="checkbox" id="CybotCookiebotDialogBodyLevelButtonMarketing" class="CybotCookiebotDialogBodyLevelButton CybotCookiebotDialogBodyLevelConsentCheckbox"
data-target="CybotCookiebotDialogBodyLevelButtonMarketingInline" checked="checked" tabindex="0"> <span class="CybotCookiebotDialogBodyLevelButtonSlider"></span></div>
</div>
</div>
</fieldset>
</form><form><input type="checkbox" id="CybotCookiebotDialogBodyLevelButtonNecessaryInline" class="CybotCookiebotDialogBodyLevelButton CybotCookiebotDialogBodyLevelButtonDisabled" disabled="disabled" checked="checked"> <span
class="CybotCookiebotDialogBodyLevelButtonSlider"></span></form><form><input type="checkbox" id="CybotCookiebotDialogBodyLevelButtonPreferencesInline" class="CybotCookiebotDialogBodyLevelButton CybotCookiebotDialogBodyLevelConsentCheckbox" data-target="CybotCookiebotDialogBodyLevelButtonPreferences"
checked="checked" tabindex="0"> <span class="CybotCookiebotDialogBodyLevelButtonSlider"></span></form><form><input type="checkbox" id="CybotCookiebotDialogBodyLevelButtonStatisticsInline" class="CybotCookiebotDialogBodyLevelButton CybotCookiebotDialogBodyLevelConsentCheckbox" data-target="CybotCookiebotDialogBodyLevelButtonStatistics"
checked="checked" tabindex="0"> <span class="CybotCookiebotDialogBodyLevelButtonSlider"></span></form><form><input type="checkbox" id="CybotCookiebotDialogBodyLevelButtonMarketingInline" class="CybotCookiebotDialogBodyLevelButton CybotCookiebotDialogBodyLevelConsentCheckbox" data-target="CybotCookiebotDialogBodyLevelButtonMarketing" checked="checked"
tabindex="0"> <span class="CybotCookiebotDialogBodyLevelButtonSlider"></span></form><form class="CybotCookiebotDialogBodyLevelButtonSliderWrapper"><input type="checkbox" id="CybotCookiebotDialogBodyContentCheckboxPersonalInformation" class="CybotCookiebotDialogBodyLevelButton"> <span
class="CybotCookiebotDialogBodyLevelButtonSlider"></span></form>GET /office-addins-blog/search.php
<form role="search" method="get" class="bemSearchForm bemSearchForm--Blog" action="/office-addins-blog/search.php">
<input type="search" id="id-search-form-input" class="bemSearchForm__Input bemSearchForm__Input--Blog" required="" placeholder="Search (powered by Google)" value="" name="search">
<button style="cursor: pointer;" type="submit" aria-label="Search in blog" class="bemSearchForm__Button bemSearchForm__Button--Blog"></button>
</form>POST https://www.ablebits.com/office-addins-blog/wp-comments-post.php
<form action="https://www.ablebits.com/office-addins-blog/wp-comments-post.php" method="post" id="commentform" class="a20commentform-From">
<input class="a20commentform-Input a20commentform-Input--Name sFormCheckValue" type="text" name="author" id="author" value="" size="22" placeholder="Your name" required="" autocomplete="name">
<input class="a20commentform-Input a20commentform-Input--Email sFormCheckValue" type="email" name="email" id="email" value="" size="22" placeholder="E-mail (not published)" autocomplete="email">
<textarea required="" class="a20commentform-Input a20commentform-Input--Body sFormCheckValue" name="comment" id="comment" rows="7" placeholder="Your comment"></textarea>
<label class="a19ContactForm-Checkbox a19ContactForm-Checkbox--Privacy">
<input type="checkbox" name="agreement" required="" class="a20commentform-Input a19ContactForm-CheckboxInput sFormCheckValue">
<span class="a19ContactForm-CheckboxStyle"></span> I have read and accept the <a class="a19Section-Link" target="_blank" href="https://www.ablebits.com/docs/ablebits-terms-of-use/">Terms of use</a> and
<a class="a19Section-Link" target="_blank" href="https://www.ablebits.com/docs/ablebits-privacy-policy/">Privacy Policy</a>
</label>
<div id="submit-frame">
<input class="a20commentform-Button" id="sendcomment" type="submit" value="Send">
<input type="hidden" name="comment_post_ID" value="17007" id="comment_post_ID">
<input type="hidden" name="comment_parent" id="comment_parent" value="0">
<br><br>
</div>
<p style="display: none;"><input type="hidden" id="akismet_comment_nonce" name="akismet_comment_nonce" value="f0ded43856"></p>
<p style="display: none !important;"><label>Δ<textarea name="ak_hp_textarea" cols="45" rows="8" maxlength="100"></textarea></label><input type="hidden" id="ak_js_1" name="ak_js" value="1687895387087">
<script>
document.getElementById("ak_js_1").setAttribute("value", (new Date()).getTime());
</script>
</p><small class="b22PostNote b22PostNote--Form">Thank you for your comment!<br> When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to<br> your query. We cannot guarantee that we will
answer every question, but we'll do our best :)</small>
</form>Text Content
Powered by Cookiebot
* Consent
* Details
* [#IABV2SETTINGS#]
* About
COOKIES AND SIMILAR TECHNOLOGIES ON OUR WEBSITE.
When you use and access our website, we may place several cookie files in your
web browser. We use cookies for the following purposes: to enable certain
functions of website, to collect analytics, to store your preferences, to enable
advertisements delivery, including behavioral advertising.
Consent Selection
Necessary
Preferences
Statistics
Marketing
Show details
Necessary 11
We used necessary Cookies to operate the core functions of our website, so that
you may visit and move around it, and use its features. We do not require your
consent to use these Cookies, but you may be able to block these Cookies
yourself on your device. However, without these Cookies, our website is unlikely
to work as you would expect and certain services that you may ask for, for
example, signing into your online account, cannot be provided.
Where we process personal data using these necessary Cookies, we do so on the
basis of our legitimate interests to provide a website for visitors to use and
to promote our business. You can find more information in our Cookies Policy
(https://www.ablebits.com/docs/ablebits-cookies-policy/).
Cookiebot
1
Learn more about this provider
CookieConsentStores the user's cookie consent state for the current domain.
Expiry: 1 yearType: HTTP
Microsoft
5
Learn more about this provider
#-ARRAffinity [x2]Used to distribute traffic to the website on several servers
in order to optimise response times.
Expiry: SessionType: HTTP
ENecessary for the sign-up function on the website.
Expiry: SessionType: HTTP
wla42Pending
Expiry: 7 daysType: HTTP
x#Necessary for the shopping cart functionality on the website.
Expiry: SessionType: HTTP
Zendesk
3
Learn more about this provider
ZD-suidUnique id that identifies the user's session.
Expiry: PersistentType: HTML
__cfruidThis cookie is a part of the services provided by Cloudflare - Including
load-balancing, deliverance of website content and serving DNS connection for
website operators.
Expiry: SessionType: HTTP
AWSALBCORSRegisters which server-cluster is serving the visitor. This is used in
context with load balancing, in order to optimize user experience.
Expiry: 6 daysType: HTTP
play.google.com
youtube-nocookie.com
2
CONSENT [x2]Used to detect if the visitor has accepted the marketing category in
the cookie banner. This cookie is necessary for GDPR-compliance of the website.
Expiry: 2 yearsType: HTTP
Preferences 3
We may use preferences Cookies to remember information that changes the way the
website behaves or looks, such as the "Show Chat" functionality of a user or
other preference.
Ablebits
1
Learn more about this provider
bn-suite-smallAppearance of Ultimate Suite advertising banner (false - show full
banner, true - minimized banner)
Expiry: 6 monthsType: HTTP
Zendesk
2
Learn more about this provider
__zlcstoreThis cookie is necessary for the chat-box function on the website to
function.
Expiry: PersistentType: HTML
ZD-storeRegisters whether the self-service-assistant Zendesk Answer Bot has been
displayed to the website user.
Expiry: PersistentType: HTML
Statistics 10
Statistic Cookies help us to understand how you interact with our website by
collecting and reporting information anonymously.
Ablebits
3
Learn more about this provider
ab-lpagePending
Expiry: 188 daysType: HTTP
ab-refPending
Expiry: 188 daysType: HTTP
ab-uslp-vPending
Expiry: 6 monthsType: HTTP
Google
4
Learn more about this provider
_gaRegisters a unique ID that is used to generate statistical data on how the
visitor uses the website.
Expiry: 399 daysType: HTTP
_ga_#Used by Google Analytics to collect data on the number of times a user has
visited the website as well as dates for the first and most recent visit.
Expiry: 399 daysType: HTTP
_gatUsed by Google Analytics to throttle request rate.
Expiry: 1 dayType: HTTP
_gidRegisters a unique ID that is used to generate statistical data on how the
visitor uses the website.
Expiry: 1 dayType: HTTP
Microsoft
2
Learn more about this provider
MR [x2]Indicates whether to refresh MUID.
Expiry: 6 daysType: HTTP
Zendesk
1
Learn more about this provider
ZD-buidUnique id that identifies the user on recurring visits.
Expiry: PersistentType: HTML
Marketing 20
We may use marketing Cookies to test new advertisements, pages, features, or new
functionality of the website to see how our users react to them.
Microsoft
8
Learn more about this provider
MUID [x2]Used widely by Microsoft as a unique user ID. The cookie enables user
tracking by synchronising the ID across many Microsoft domains.
Expiry: 1 yearType: HTTP
SRM_BTracks the user’s interaction with the website’s search-bar-function. This
data can be used to present the user with relevant products or services.
Expiry: 1 yearType: HTTP
SRM_L [x2]Tracks the user’s interaction with the website’s search-bar-function.
This data can be used to present the user with relevant products or services.
Expiry: 1 yearType: HTTP
ANONCHKRegisters data on visitors from multiple visits and on multiple websites.
This information is used to measure the efficiency of advertisement on websites.
Expiry: 1 dayType: HTTP
SMRegisters a unique ID that identifies the user's device during return visits
across websites that use the same ad network. The ID is used to allow targeted
ads.
Expiry: SessionType: HTTP
xidSets a unique ID for the visitor, that allows third party advertisers to
target the visitor with relevant advertisement. This pairing service is provided
by third party advertisement hubs, which facilitates real-time bidding for
advertisers.
Expiry: SessionType: HTTP
YouTube
10
Learn more about this provider
yt.innertube::nextIdRegisters a unique ID to keep statistics of what videos from
YouTube the user has seen.
Expiry: PersistentType: HTML
yt.innertube::requestsRegisters a unique ID to keep statistics of what videos
from YouTube the user has seen.
Expiry: PersistentType: HTML
ytidb::LAST_RESULT_ENTRY_KEYStores the user's video player preferences using
embedded YouTube video
Expiry: PersistentType: HTML
yt-remote-cast-availableStores the user's video player preferences using
embedded YouTube video
Expiry: SessionType: HTML
yt-remote-cast-installedStores the user's video player preferences using
embedded YouTube video
Expiry: SessionType: HTML
yt-remote-connected-devicesStores the user's video player preferences using
embedded YouTube video
Expiry: PersistentType: HTML
yt-remote-device-idStores the user's video player preferences using embedded
YouTube video
Expiry: PersistentType: HTML
yt-remote-fast-check-periodStores the user's video player preferences using
embedded YouTube video
Expiry: SessionType: HTML
yt-remote-session-appStores the user's video player preferences using embedded
YouTube video
Expiry: SessionType: HTML
yt-remote-session-nameStores the user's video player preferences using embedded
YouTube video
Expiry: SessionType: HTML
Zendesk
2
Learn more about this provider
__zlcmidPreserves users states across page requests.
Expiry: 1 yearType: HTTP
zte#Saves a Zopim Live Chat ID that recognises a device between visits during a
chat session.
Expiry: SessionType: HTTP
Unclassified 0
Unclassified cookies are cookies that we are in the process of classifying,
together with the providers of individual cookies.
We do not use cookies of this type.
Cross-domain consent[#BULK_CONSENT_DOMAINS_COUNT#] [#BULK_CONSENT_TITLE#]
List of domains your consent applies to: [#BULK_CONSENT_DOMAINS#]
Cookie declaration last updated on 04.06.23 by Cookiebot
[#IABV2_TITLE#]
[#IABV2_BODY_INTRO#]
[#IABV2_BODY_LEGITIMATE_INTEREST_INTRO#]
[#IABV2_BODY_PREFERENCE_INTRO#]
[#IABV2_LABEL_PURPOSES#]
[#IABV2_BODY_PURPOSES_INTRO#]
[#IABV2_BODY_PURPOSES#]
[#IABV2_LABEL_FEATURES#]
[#IABV2_BODY_FEATURES_INTRO#]
[#IABV2_BODY_FEATURES#]
[#IABV2_LABEL_PARTNERS#]
[#IABV2_BODY_PARTNERS_INTRO#]
[#IABV2_BODY_PARTNERS#]
Cookies are small data files that are sent to your web browser by a website you
visit. A cookie file is stored in your web browser and allows our website or a
third-party to recognize you and make your next visit easier and make our
website more useful to you.
The law states that we can store cookies on your device if they are strictly
necessary for the operation of this site. For all other types of cookies we need
your permission. This means that cookies which are categorized as necessary, are
processed based on GDPR Art. 6 (1) (f). All other cookies, meaning those from
the categories preferences and marketing, are processed based on GDPR Art. 6 (1)
(a) GDPR.
For latest Cookies Policy, go
to: https://www.ablebits.com/docs/ablebits-cookies-policy/
You can at any time change or withdraw your consent on our website.
Please state your consent ID and date when you contact us regarding your
consent.
Do not sell or share my personal information
Deny Allow selection Customize
Allow all
Powered by Cookiebot by Usercentrics
1. Ablebits blog
2. Excel
3. Excel charts
HOW TO CREATE A SCATTER PLOT IN EXCEL
by Svetlana Cheusheva, updated on March 16, 2023
In this tutorial, you will learn how to do a scatter plot in Excel to create a
graphical representation of two correlated data sets.
When looking at two columns of quantitative data in your Excel spreadsheet, what
do you see? Just two sets of numbers. Do you want to see how the two sets are
related to each other? The scatter plot is the ideal graph choice for this.
* Scatter plot in Excel
* How to organize data for a scatter chart
* How to make a scatter plot in Excel
* Scatter chart types
* 3D scatter plot in Excel
* Scatter graph and correlation
* Customizing scatter plot
* Adjust the axis scale to reduce white space
* Add Excel scatter plot labels
* Add a trendline
* Swap X and Y data series
SCATTER PLOT IN EXCEL
A scatter plot (also called an XY graph, or scatter diagram) is a
two-dimensional chart that shows the relationship between two variables.
In a scatter graph, both horizontal and vertical axes are value axes that plot
numeric data. Typically, the independent variable is on the x-axis, and the
dependent variable on the y-axis. The chart displays values at the intersection
of an x and y axis, combined into single data points.
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 SCATTER CHART
With a variety of inbuilt chart templates provided by Excel, creating a scatter
diagram turns into a couple-of-clicks job. But first, you need to arrange your
source data properly.
As already mentioned, a scatter graph displays two interrelated quantitative
variables. So, you enter two sets of numeric data into two separate columns.
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 y axis.
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 EXCEL
With the source data correctly organized, making a scatter plot in Excel takes
these two quick steps:
1. Select two columns with numeric data, including the column headers. In our
case, it is the range C1:D13. Do not select any other columns to avoid
confusing Excel.
2. Go to the Inset tab > Chats group, click the Scatter chart icon, and select
the desired template. To insert a classic scatter graph, click the first
thumbnail:
The scatter diagram will be immediately inserted in your worksheet:
Basically, you may consider the work done. Or, you can customize some elements
of your graph to make it look more beautiful and to convey the correlation
between the two variables clearer.
SCATTER CHART TYPES
Besides the classic scatter plot shown in the above example, a few more
templates are available:
* Scatter with smooth lines and markers
* Scatter with smooth lines
* Scatter with straight lines and markers
* Scatter with straight lines
Scatter with 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 markers:
The Excel XY plot templates can also draw each variable separately, presenting
the same relationships in a different way. For this, you should select 3 columns
with data - the leftmost column with text values (labels), and the two columns
with numbers.
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 CORRELATION
To interpret the scatter plot correctly, you need to understand how the
variables can relate to each other. Overall, there exist three types of
correlation:
Positive Correlation - as the x variable increases, so does the y variable. An
example of a strong positive correlation is the amount of time the students
spend studying and their grades.
Negative Correlation - as the x variable increase, the y variable decreases.
Ditching classes and grades are negatively correlated - as the number of
absences increases, the exam scores decrease.
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 EXCEL
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.
Below we will focus on a few customizations specific to a scatter plot.
ADJUST THE AXIS SCALE (REDUCE WHITE SPACE)
In case your data points are clustered at the top, bottom, right, or left side
of the graph, you may want to clean up the extra white space.
To reduce the space between the first data point and the vertical axis and/or
between the last data point and the right edge of the graph, perform these
steps:
1. Right-click the x axis, and click Format Axis…
2. On the Format Axis pane, set the desired Minimum and Maximum bounds as
appropriate.
3. Additionally, you can change the Major units that control the spacing
between the gridlines.
The below screenshot shows my settings:
To remove space between the data points and the top/bottom edges of the plot
area, format the vertical y axis in a similar manner.
ADD LABELS TO SCATTER PLOT DATA POINTS
When creating a scatter graph with a relatively small number of data points, you
may wish to label the points by name to make your visual better understandable.
Here's how you can do this:
1. Select the plot and click the Chart Elements button.
2. Tick off the Data Labels box, click the little black arrow next to it, and
then click More Options…
3. 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 Cells box, and then select the range from which you
want to pull data labels (B2:B6 in our case).
* 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 example.
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 Mar labels in our scatter diagram. To
fix this, click on the labels, and then click on the overlapping one so that
only that label gets selected. Point your mouse cursor to the selected label
until the cursor changes to the four-sided arrow, and then drag the label to the
desired position.
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.
Excel will draw a line as close as possible to all data points so that there are
as many points above the line as below.
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 this:
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 SCATTER CHART
As already mentioned, a scatter plot usually displays the independent variable
on the horizonal axis and the dependent variable on the vertical axis. If your
graph is plotted differently, the easiest fix is to swap the source columns in
your worksheet, and then draw the chart anew.
If for some reason rearranging the columns is not possible, you can switch the X
and Y data series directly on a chart. Here's how:
1. Right-click any axis and click Select Data… in the context menu.
2. In the Select Data Sourcedialog window, click the Edit button.
3. 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 F2.
4. 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.
That's how you create a scatter plot in Excel. In our next tutorial, we will
continue with this topic and show how to quickly find and highlight a certain
data point in a scatter graph. Please stay tuned!
YOU MAY ALSO BE INTERESTED IN
* How to make a graph in Excel
* How to customize an Excel chart
* Make an Excel chart from different sheets
* How to make a heat map in Excel
* How to create a Pareto chart in Excel
* Highlight active row and column in Excel
* How to draw a line graph in Excel
EXCEL: FEATURED ARTICLES
* Merge multiple sheets into one
* Combine Excel files into one
* Compare two files / worksheets
* Merge 2 columns in Excel
* Compare 2 columns in Excel for matches and differences
* How to merge two or more tables in Excel
* CONCATENATE in Excel: combine text strings, cells and columns
* Create calendar in Excel (drop-down and printable)
* 3 ways to remove spaces between words
Table of contents
* Scatter plot in Excel
* How to organize data for a scatter chart
* How to make a scatter plot in Excel
* Scatter chart types
* 3D scatter plot in Excel
* Scatter graph and correlation
* Customizing scatter plot
* Adjust the axis scale to reduce white space
* Add Excel scatter plot labels
* Add a trendline
* Swap X and Y data series
* Related articles
* Products
Windows
Ultimate Suite for Excel Shared Email Templates for Outlook Mail Merge for
Outlook Link Checker for Word
Mac Os
Text Toolkit for Excel Shared Email Templates for Outlook Mail Merge for
Outlook
Outlook Online
Shared Email Templates for Outlook Mail Merge for Outlook
Google Workspace
Add-ons for Google Sheets Add-ons for Google Docs
Ultimate Suite
70+ professional tools for Microsoft Excel
This comprehensive set of time-saving tools covers over 300 use cases to help
you accomplish any task impeccably without errors or delays.
* Merge multiple worksheets
* Compare sheets for differences
* Remove duplicates
* Merge cells in Excel
* Calculate dates and times
* Combine sheets by column headers
* Trim extra spaces
* Count characters and words
* Convert text to number
* See all tools
Works for: Windows
Read more about Ultimate Suite
Shared Email Templates
Reply to routine emails faster than ever
Do not waste your time on composing repetitive emails from scratch in a
tedious keystroke-by-keystroke way. Type your response just once, save it as
a template and reuse whenever you want.
* Quick replies for routine emails
* Fully customizable templates
* Gorgeous html-based designs
* Dynamic templates with fillable fields
* Comfortable template sharing
* Custom-tailored bulk mailings
* Company and team-wide signatures
* Easy user and team management
Works for: Windows•macOS•Outlook Online
Read more about Shared Email Templates
Link Checker for Microsoft Word
Manage links in your document with ease
Find all links in your document, get them verified, correct invalid ones and
remove unnecessary entries with a click to keep your document neat and up to
date.
* Search for all link types
* Define link states
* Edit multiple hyperlinks at a time
* Sort and filter links by different criteria
Works for: Windows
Read more about Link Checker
Text Toolkit for Excel
35+ handy options to make your text cells perfect
Instead of building formulas or performing intricate multi-step operations,
start the add-in and have any text manipulation accomplished with a mouse
click.
* Trim extra spaces
* Convert text to numbers
* Count characters and words
* Change letter case
* Extract text or numbers
* Remove text by its position
* Split cells by symbol, string, or mask
* Replace unwanted characters
* Eliminate leading zeros
* Swap text in your cells
* Find, extract, replace, and remove strings by means of regexes
* Merge columns, rows, or cells into one
* Combine rows by duplicates
Works for: macOS•Excel Online
Read more about Text Toolkit
30+ tools to boost your Google Sheets
This smart package will ease many routine operations and solve complex
tedious tasks in your spreadsheets.
Read more about Power Tools Try it for free
Add-ons for Google Sheets
Merge Sheets Function by Color Remove Duplicates Compare Sheets Combine
Sheets Table Styles Advanced Find and Replace See all products
Add-ons for Google Docs
Search & Navigate Doc Tools Styles for Google Docs
Mail Merge
Ideal for newsletters, proposals, and greetings addressed to your personal
contacts
Mail Merge is a time-saving approach to organizing your personal email
events. It offers:
* Customizable and adaptive mail merge templates
* Personalized merge fields depending on the recipient or context
* Dynamic attachments and images
* Mailing lists based on Excel tables
* "Send immediately" and "send later" scheduling
Works for: Windows•macOS•Outlook Online
Read more about Mail Merge
* Downloads
* Current versions
* Archived versions
* Documentation
* Support
* Contact support service
* Report a bug
* Frequently asked questions
* Blog
* About us
* Purchase
* Buy online
* Customer reviews
* Purchasing FAQ
* Licensing FAQ
* Get a Formal Quote
* Purchase Orders
* Trusted resellers
* License Agreement (EULA)
* Ultimate Suite for Excel
* Shared Email Templates for Outlook
* Power Tools for Google Sheets
* Downloads
* Documentation
* Support
* Blog
* About us
* Purchase
13 COMMENTS
1. HXK says:
2021-03-13 at 2:32 pm
This doesn't work - why the hell is Excel so counter-intuitive, you'd think
selecting two columns of numeric data and clicking on scatter graph would
make a simple scatter graph, wouldn't you? Not in the Microsoft world where
the whole idea is that you need to be 'trained' to use Microsoft
applications. Excel is, even more than it heretofore, an absolute piece of
garbage.
Reply
* AC says:
2021-08-17 at 4:17 pm
You bet!
Reply
2. Ma.B says:
2021-02-26 at 8:44 pm
in "How to switch X and Y axes in a scatter chart" why do it? I can not
understand this and I can not do this.
Reply
* Svetlana Cheusheva says:
2021-03-15 at 9:30 am
Hello!
In a a scatter plot, the independent variable is normally displayed on
the horizonal axis (X) and the dependent variable on the vertical axis
(Y). If, for whatever reason, your variables are plotted the other way
round, you can swap the axes directly on the graph.
Reply
3. Steph says:
2020-07-15 at 1:02 am
On my X axis I want Day 1, Day 2 upto Day 6. But I have multiple data
points per day, so my X axis is 0-12 as I have 12 data points over the
first 4 days....how do I change to Day 1, Day 2 etc.?
Reply
4. Dr David Morley says:
2020-06-18 at 2:04 pm
In my rather old Microsoft Office, when you make a scatter plot, the points
are coloured rectangles and they are rather large. Is there a way to make
them smaller and, preferably into circular dots ?
Reply
5. Talha says:
2020-02-28 at 8:45 am
I have had this issue, where i was unable to get them with group colors,
taking the above example into consideration i want to represent dots with
different color based over month.
Please suggest a solution
Reply
6. Harun says:
2019-09-03 at 7:46 am
Thank you very much, this was very useful!
Reply
7. Nils says:
2019-08-12 at 8:36 pm
If having Cartesian Unit Coordianates in XYZ As in (0,500,0)
It would be nice to be able to draw a 3D shape by Coordinates.
(0,0,0) where first digit is X, 2nd is Y and 3rd is Z ...
Reply
8. Linn Bjurek says:
2019-04-05 at 7:47 am
I'm trying to show my labels in a X & Y-chart and I thougt i found the
solution when finding this site. Others say you need to write a macro of
your own.
My problem now:
Under Label options/Label contains I see four boxes:
Series namn, X value, Y value and Legend key. I don't see the "Value from
Cells"-box.
Why so?
Reply
9. Tobias Holm Johansen says:
2019-03-01 at 12:02 pm
If I have a set of connected sample data for x and y values that varies in
size, but I want them to be plotted in order of numerical size, how do I
sort them without manually moving around the data entries. As an analogy in
letters I have the letters 'b' , 'f' and 'd' but I want to plot them in
alphabetical order so they appear from left to right as 'b','d','f'.
The corresponding y-values would obviously have to follow so they stay with
their x-value.
Reply
10. Indraditya Sarkar says:
2019-02-10 at 3:18 am
I do not have the plus button you have for your graph
Also, I have never said this so why am I getting a duplicate response?
Reply
* Svetlana Cheusheva says:
2019-02-11 at 8:33 am
Hi!
Just click anywhere on the chart for the plus button (Chart Elements
button) to appear.
And sorry for the "duplicate response" message, our webmaster is working
on it already.
Reply
Post a comment
Click here to cancel reply.
I have read and accept the Terms of use and Privacy Policy
Δ
Thank you for your comment!
When posting a question, please be very clear and concise. This will help us
provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do
our best :)
Privacy policy Cookies policy Cookie settings Terms of use Legal
Contact us
Copyright © 2003 – 2023 Office Data Apps sp. z o.o.
70+ professional tools for Excel
70+ professional tools for Excel
2021–2016 to do your daily work
, 1-Jan-30
Buy this product! It's worth every penny!
Kevin Jacobs, 16-May-23
Professional solutions!
Douglas, 11-May-23
I wouldn't be able to do my job without Ablebits!
Julie Barie, 9-May-23
Fantastic program at a reasonable price
Cliff, 28-Apr-23
A+ product and service team
T Shaner, 18-Apr-23
5 Stars from me. Great add-in that I use daily
Derek Balfe, 10-Apr-23
Need Excel, you will want Ablebits Ultimate Suite
Kory Hirak, 7-Apr-23
Time saver and excellent support makes Ultimate Suite a no-brainer
Santosh, 22-Mar-23
Hooked on this product
Vicki R, 16-Mar-23
I've been using the Ablebits product for several years
Lynette, 1-Mar-23
AbleBits automated my entire Excel life
Andrew Binno, 20-Feb-23
Ultimate Suite turns Excel into what it should have always been
Rick Polete, 8-Feb-23
Inexpensive with TONS of value!
Debbie Foster, 29-Jan-23
Can't live without it
Julie Bradley, 17-Jan-23
Ablebits occupies a unique place for Excel users
Barry Beiles, 16-Jan-23
Absolutely worth every penny!
Dave, 30-Dec-22
Just one great product and a great company!
Don Scarpetti, 23-Dec-22
A wonderful feeling to be amazed by a product
Deon van Niekerk, 17-Dec-22
The Ablebits Excel add-in is an absolute must have
Dave Tarantelli, 16-Dec-22
The software is the real deal
Christopher Rotolo, 15-Dec-22
I would be lost without it
Marc Lajoie, 28-Nov-22
It's a lifesaver!
Lauri Pantos, 28-Nov-22
Great product - even better service
Alan Perestrello, 28-Nov-22
Ablebits has saved me countless hours!
PJ Kuyper, 25-Nov-22
A life and time saving tool with great customer service!
Paul Gittens, 11-Nov-22
Can't go without it
Alisha Benish, 7-Nov-22
It is a game changer!
Eric F Carr, 5-Nov-22
We discovered a gold mine!
Rebecca D. Becker, 25-Oct-22
I highly recommend the Ablebits Ultimate Suite
Adam Pressman, 25-Oct-22
Would recommend it to anyone who works with Excel
Judy Groom, 20-Oct-22
Save hours of your life
Pennelope Blakely Kunkle, 18-Oct-22
Ablebits makes magic
Tracey Miller, 11-Oct-22
I have found the Ablebits app and website to be extremely useful
James F Joyner III, 25-Sep-22
Ablebits Ultimate Suite is invaluable if you work with spreadsheets
Jodi V., 20-Sep-22
Extremely useful add-in with extensive functionality
Doug Walters, 20-Sep-22
The best add-in for anyone
Jeff Garris, 19-Sep-22
Exceptional product and service
Michael Toney, 24-Aug-22
Excellent product and support!
Daniel Klaus, 17-Aug-22
It is a productivity multiplier!
Jess Fowler, 12-Aug-22
If that's not good service, I don't know what is
Jason Velez, 11-Aug-22
My Excel life changed a lot… for the better!
Marco Antonio Gonçalves, 10-Aug-22
Ultimate Suite is a treasure chest of useful tools
Mark Newbold, 28-Jul-22
The best tools. Exactly what I needed
Emily Brown, 26-Jul-22
AbleBits has been a huge time saver
Martin Weinberg, 17-Jul-22
That one program has given me years of convenience
Liz Kaminski, 15-Jul-22
Ablebits is a dream come true for any Excel user
Ilse Assmann, 7-Jul-22
This add-in is really valuable for a very reasonable cost
James Kennedy, 6-Jul-22
We couldn't imagine being without this tool!
Pat Rorabeck, 28-Jun-22
Ablebits has allowed us to reduce timescale from hour to around 5-10 minutes
Thomas Savine, 23-Nov-20
This software is by far the best I have ever purchased
Gary Loar, 21-Jul-20
This product changed my working and investing experience
Tony Brinker, 23-Jun-20
Ablebits offers amazing services!
Lanita Warner, 27-Apr-20