{"id":31463,"date":"2023-10-09T02:59:06","date_gmt":"2023-10-09T00:59:06","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=31463"},"modified":"2024-06-12T19:57:09","modified_gmt":"2024-06-12T17:57:09","slug":"how-to-create-scatter-plot-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-create-scatter-plot-in-excel\/","title":{"rendered":"How to Create Scatter Plot in Excel"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/46590874-93B9-4B79-8BAD-A4201C37F8EE.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-31488\" title=\"How to Create Scatter Plot in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/46590874-93B9-4B79-8BAD-A4201C37F8EE-1024x576.png\" alt=\"How to Create Scatter Plot in Excel\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/46590874-93B9-4B79-8BAD-A4201C37F8EE-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/46590874-93B9-4B79-8BAD-A4201C37F8EE-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/46590874-93B9-4B79-8BAD-A4201C37F8EE-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/46590874-93B9-4B79-8BAD-A4201C37F8EE.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>A scatter plot is a type of <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/61-excel-charts-examples\/\" target=\"_blank\" rel=\"nofollow noopener\"><strong>Excel Chart<\/strong><\/a> that displays individual data points on a two-dimensional graph. It is particularly useful for visualizing the relationship between two variables. In this article, we will cover the following topics in detail &#8211;<\/p>\n<p>Download the Excel Workbook below to follow along and understand How to Create Scatter Plot in Excel \u2013\u00a0<a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-in-Excel.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel workbook<\/strong><\/span><span class=\"postTitle px-3\">Scatter-Plot-in-Excel.xlsx<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><strong><span id=\"1\" style=\"color: #ff0000\">Introduction to Scatter Plot<\/span><\/strong><\/h3>\n<p><span style=\"font-weight: 400\">A <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/xy-scatter-chart-related-variables\/\" target=\"_blank\"><strong>Scatter Plot<\/strong><\/a> is an Excel Chart that helps in comparing variables or numerical values showing the relationship between the two. It helps to find out whether or not these variables are related. Each point on the graph corresponds to the values of two variables, and the position of the point is determined by its x and y coordinates.<\/span><\/p>\n<p>Based on the pattern of the data points, you can determine the correlation between the two variables &#8211;<\/p>\n<ul>\n<li><strong>Positive Correlation<\/strong> &#8211; In a positive correlation, as <strong>one variable increases, the other variable also tends to increase<\/strong>. Similarly, as one variable decreases, the other variable tends to decrease. In this scenario, the points form an <strong>upward-sloping line<\/strong>.<\/li>\n<li><strong>Negative Correlation<\/strong> &#8211; In a negative correlation, as <strong>one variable increases, the other variable also tends to decrease<\/strong>. Similarly, as one variable decreases, the other variable tends to increase. In this scenario, the points form a <strong>downward-sloping line<\/strong>.<\/li>\n<li><strong>No Correlation<\/strong> &#8211; In the case of no correlation, there is no apparent relationship between the two variables. Changes in one variable do not predict changes in the other variable. The data points on the plot are scattered <strong>without forming a clear pattern<\/strong> or trend.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3><strong><span id=\"2\" style=\"color: #ff0000\">How to Create Scatter Plot in Excel<\/span><\/strong><\/h3>\n<p>In a local ice cream shop, the manager is interested in understanding how <strong>outdoor temperature influences the sales of ice cream<\/strong>. Data is collected over several weeks, recording the<strong> daily maximum temperature (in degrees Celsius) and the corresponding daily ice cream sales (in units)<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31464\" title=\"How to Create Scatter Plot in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-1.png\" alt=\"How to Create Scatter Plot in Excel\" width=\"336\" height=\"555\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-1.png 336w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-1-182x300.png 182w\" sizes=\"(max-width: 336px) 100vw, 336px\" \/><\/a><\/p>\n<p>You can use a scatter <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/find-slope-of-tangent-line-in-excel\/\" target=\"_blank\" rel=\"noopener\">chart to understand how<\/a> outdoor temperature influences the sales of ice cream cones.<\/p>\n<ul>\n<li>If the data points form an upward-sloping graph, it has a positive correlation.<\/li>\n<li>If the data points form a downward-sloping graph, it has a negative correlation.<\/li>\n<li>If there is no clear pattern, there is no correlation between the two.<\/li>\n<\/ul>\n<p>Follow the <strong>steps below<\/strong> to create a scatter plot in Excel &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1:<\/span><\/strong> <strong>Select the table<\/strong> with both sets of numerical values.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-8.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31471\" title=\"How to Create Scatter Plot in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-8.png\" alt=\"How to Create Scatter Plot in Excel\" width=\"269\" height=\"569\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-8.png 269w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-8-142x300.png 142w\" sizes=\"(max-width: 269px) 100vw, 269px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2:<\/span><\/strong> Go to <strong>Insert &gt; Scatter Charts &gt; Scatter.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31465\" title=\"How to Create Scatter Plot in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-2.png\" alt=\"How to Create Scatter Plot in Excel\" width=\"1090\" height=\"529\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-2.png 1090w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-2-300x146.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-2-1024x497.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-2-768x373.png 768w\" sizes=\"(max-width: 1090px) 100vw, 1090px\" \/><\/a><\/p>\n<p>A scatter chart will be inserted into the worksheet!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-3.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31466\" title=\"How to Create Scatter Plot in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-3.png\" alt=\"How to Create Scatter Plot in Excel\" width=\"1089\" height=\"592\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-3.png 1089w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-3-300x163.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-3-1024x557.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-3-768x417.png 768w\" sizes=\"(max-width: 1089px) 100vw, 1089px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 3:<\/span><\/strong> Go to <strong>Chart Design &gt; Chart Style<\/strong>. Here, you can select the preferred design to make the chart more presentable!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-4.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31467\" title=\"How to Create Scatter Plot in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-4.png\" alt=\"How to Create Scatter Plot in Excel\" width=\"1529\" height=\"171\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-4.png 1529w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-4-300x34.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-4-1024x115.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-4-768x86.png 768w\" sizes=\"(max-width: 1529px) 100vw, 1529px\" \/><\/a><\/p>\n<p>The new chart design will look like this &#8211;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-9.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31472\" title=\"How to Create Scatter Plot in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-9.png\" alt=\"How to Create Scatter Plot in Excel\" width=\"1041\" height=\"577\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-9.png 1041w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-9-300x166.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-9-1024x568.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-9-768x426.png 768w\" sizes=\"(max-width: 1041px) 100vw, 1041px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 4:<\/span><\/strong> You can <strong>label the x-axis and y-axis<\/strong>\u00a0to make your chart more informative. Click on the chart, go to the<strong>\u00a0Chart Elements<\/strong>\u00a0button, and check the\u00a0<strong>Axis Titles<\/strong> option.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-5.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31468\" title=\"How to Create Scatter Plot in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-5.png\" alt=\"How to Create Scatter Plot in Excel\" width=\"1010\" height=\"493\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-5.png 1010w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-5-300x146.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-5-768x375.png 768w\" sizes=\"(max-width: 1010px) 100vw, 1010px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 5: <\/span><\/strong>Type Temperature in the X-axis and Ice Cream Sales in the Y-axis.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-6.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31469\" title=\"How to Create Scatter Plot in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-6.png\" alt=\"How to Create Scatter Plot in Excel\" width=\"688\" height=\"418\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-6.png 688w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-6-300x182.png 300w\" sizes=\"(max-width: 688px) 100vw, 688px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 6:<\/span><\/strong> Click on the chart, go to the<strong>\u00a0Chart Elements<\/strong> button, and check the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-trendlines-excel-charts\/\" target=\"_blank\" rel=\"nofollow noopener\"><strong>Trendline<\/strong><\/a> option to add a trendline.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-7.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31470\" title=\"How to Create Scatter Plot in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-7.png\" alt=\"How to Create Scatter Plot in Excel\" width=\"978\" height=\"442\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-7.png 978w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-7-300x136.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Scatter-Plot-7-768x347.png 768w\" sizes=\"(max-width: 978px) 100vw, 978px\" \/><\/a><\/p>\n<p>Looking at the scatter plot, we can observe a <strong>positive<\/strong> correlation. As the <strong>outdoor temperature increases, there is a general trend of higher ice cream sales<\/strong>. This suggests that there is a<strong> positive relationship<\/strong> between temperature and ice cream sales.<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><span id=\"3\" style=\"color: #ff0000\">Application of Scatter Plot<\/span><\/strong><\/h3>\n<p>The real-world applications of scatter plots in Excel are vast and diverse. Some of them are mentioned below &#8211;<\/p>\n<ul>\n<li><strong>Finance<\/strong> &#8211; Analyze the relationship between interest rates and stock prices to make informed investment decisions.<\/li>\n<li><strong>Marketing<\/strong> &#8211; Determine how marketing expenses impact product sales and identify the optimal advertising budget.<\/li>\n<li><strong>Environmental Science<\/strong> &#8211; Explore the connection between pollution levels and public health outcomes in different regions.<\/li>\n<li><strong>Manufacturing<\/strong> &#8211; Monitor the correlation between manufacturing process variables and product quality.<\/li>\n<li><strong>Sports Analytics<\/strong> &#8211; Investigate the relationship between player statistics and team performance in sports like basketball or soccer.<\/li>\n<li><strong>HR Analytics<\/strong> &#8211; Audit the relationship between high attrition rate and employee well-being in an organization.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3><strong><span id=\"4\" style=\"color: #ff0000\">Conclusion<\/span><\/strong><\/h3>\n<p>A Scatter plot <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/lineweaver-burk-plot-in-excel\/\" target=\"_blank\" rel=\"noopener\">in Excel<\/a> is a powerful tool for visually representing the relationship between two variables. The relationship can be positive, negative, or no correlation at all. This article covers the introduction to scatter plots, step-by-step guidance on <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/heatmap-creator-in-excel\/\" target=\"_blank\" rel=\"noopener\">creating them in Excel<\/a>, and their practical applications across various fields.<\/p>\n<p>After going through this article, you will surely be able to interpret the scatter chart and draw meaningful insights from the presented data.<\/p>\n<p><a href=\"https:\/\/support.microsoft.com\/en-us\/topic\/present-your-data-in-a-scatter-chart-or-a-line-chart-4570a80f-599a-4d6b-a155-104a9018b86e#:~:text=the%20Office%20theme.-,Create%20a%20scatter%20chart,%2C%20labels%2C%20and%20the%20legend.\" target=\"_blank\" rel=\"nofollow noopener\"><strong>Click here<\/strong><\/a> to learn more about Scatter Plot in Excel!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A scatter plot is a type of Excel Chart that displays individual data points on a two-dimensional graph. It is particularly useful for visualizing the relationship between two variables. In this article, we will cover the following topics in detail &#8211; Download the Excel Workbook below to follow along and understand How to Create Scatter [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":31488,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"How to Create Scatter Plot in Excel","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[5,30],"tags":[1400,1398,1399],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/31463"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=31463"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/31463\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/31488"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=31463"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=31463"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=31463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}