- \n
- What is Scatter Plot<\/strong><\/a><\/li>\n
- Scatter Plot in Excel \u2013 when You Should Use It<\/strong><\/a><\/li>\n
- Create a Basic Scatter Plot Chart<\/strong><\/a><\/li>\n
- Add Data Labels to Scatter Plot<\/strong><\/a><\/li>\n
- Scatter Plot with Smooth Lines<\/strong><\/a><\/li>\n
- Scatter Plot with Smooth Lines and Markers<\/strong><\/a><\/li>\n
- Scatter Plot with Straight Lines and Markers<\/strong><\/a><\/li>\n
- Create Bubble Chart in Excel<\/strong><\/a><\/li>\n
- How to add trendline in Scatter Plot Chart<\/strong><\/a><\/li>\n<\/ol>\n
1. What is Scatter Plot?<\/strong><\/h2>\n
Excel defines plots as graphs that correspond to the information supplied in the two columns. Plots are nothing more than scatter diagrams or scatter charts from Excel that are used to add up the data sets in two columns. Two-dimensional XY charts demonstrate the connection between the two variables and provide multiple perspectives of the data. Finding the ideal scatter plot to use for data analysis is simple.<\/p>\n
2. Scatter Plot in Excel \u2013 when You Should Use It<\/strong><\/h2>\n
You could be unsure whether an X-Y graph in Microsoft Excel is a scatter plot or a line graph. The data representation along the horizontal (X) axis is the only difference between the two.<\/p>\n
To visualize quantitative data, a scatter chart has two value axes. One set of numerical data is represented by the horizontal (X) axis, while another is represented by the vertical (Y) axis.<\/p>\n
However, the Excel line graph shows numerical values on the vertical (Y) axis and all category data on the horizontal (X) axis.<\/p>\n
You may visualize and compare numerical values obtained from statistical and scientific research by creating a scatter plot graph in Excel. You ought to employ a scatter plot rather than a line graph in the following instances:<\/p>\n
- \n
- To investigate the relationship between two sets of quantitative values. The X and Y chart will resemble a diagonal layout in appearance.<\/li>\n
- To investigate any favorable or unfavorable patterns in the variables.<\/li>\n
- To enlarge the (X) axis’s horizontal scale.<\/li>\n
- To make outliers, clusters, linear and non-linear trends visible in a big data set.<\/li>\n
- To contrast a sizable number of temporally unrelated data points.<\/li>\n<\/ul>\n
![\"Make](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Make-Scatter-Plot-1.png\")
<\/p>\n3. Create a Basic Scatter Plot Chart<\/strong><\/h2>\n
The data should be organized into two columns, as seen in the screenshot, to make the basic scatter plot excel.<\/p>\n
![\"Make](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Make-Scatter-Plot-2.png\")
<\/p>\nProcedure of creating a basic Scatter Plot chart in Excel:<\/strong><\/p>\n
Step 1: <\/strong>Pick the data first, including the two columns, such as Marketing Cost and Number of Products Sold.<\/p>\n
In this situation, the range of data is B1:C8.<\/p>\n
![\"Make](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Make-Scatter-Plot-3.png\")
<\/p>\nStep 2:<\/strong> Go to the \u201cInsert\u201d tab, click \u201cScatter Plot\u201d symbol under “Charts” section. Then select the “Scatter” plot after clicking the symbol to show how the two data sets are related, outlined in Red below.<\/p>\n
![\"Make](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Make-Scatter-Plot-4.png\")
<\/p>\nThe scatter plot is created, as seen in the picture below.<\/p>\n
![\"Make](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Make-Scatter-Plot-5.png\")
<\/p>\n4. Add Data Labels to Scatter Plot<\/strong><\/h2>\n
Follow these instructions to<\/strong> add Data labels to Scatter Plot:<\/strong><\/p>\n
Step 1:<\/strong> After making Scatter Plot, select the Chart Elements by clicking on any of the chart’s empty spaces (looks like a plus icon).<\/p>\n
![\"Make](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Make-Scatter-Plot-6.png\")
<\/p>\nStep 2:<\/strong> After that select the “Data Labels”, outlined in Red below. When you choose, the outcome appears right away.<\/p>\n
![\"Make](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Make-Scatter-Plot-8.png\")
<\/p>\n5. Scatter Plot with Smooth Lines<\/strong><\/h2>\n
Procedure of creating a Scatter Plot with Smooth Lines in Excel:<\/strong><\/p>\n
Step 1:<\/strong> To produce a simple scatter plot with smooth lines, divide the data into two columns.<\/p>\n
![\"Make](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Make-Scatter-Plot-9.png\")
<\/p>\nStep 2:<\/strong> Choose the information, including the two columns with the advertising costs, the quantity sold, and the column headers. The data range in this instance, for instance, is<\/p>\n
![\"Make](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Make-Scatter-Plot-10.png\")
<\/p>\nStep 3:<\/strong> Go to the \u201cInsert\u201d tab, click \u201cScatter Plot\u201d symbol under “Charts” section. After clicking the symbol, choose the \u201cScatter with Smooth Lines\u201d representing the relationship between the data sets, outlined in Red below.<\/p>\n
![\"Make](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Make-Scatter-Plot-11.png\")
<\/p>\nThe scatter plot is created, as seen in the picture below.<\/p>\n
![\"Make](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Make-Scatter-Plot-12.png\")
<\/p>\n6. Scatter Plot with Smooth Lines and Markers<\/strong><\/h2>\n
The procedure of creating a Scatter Plot with Smooth Lines and Markers in Excel:<\/strong><\/p>\n
Step 1:<\/strong> To produce a simple scatter plot with smooth lines, divide the data into two columns.<\/p>\n
![\"Make](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Make-Scatter-Plot-13.png\")
<\/p>\nStep 2:<\/strong> Choose the information, including the two columns with the marketing costs, the quantity sold, and the column headers. The data range in this instance, for instance, is B1:C8.<\/p>\n
![\"Make](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Make-Scatter-Plot-14.png\")
<\/p>\nStep 3:<\/strong> Go to the \u201cInsert\u201d tab, click \u201cScatter Plot\u201d symbol under “Charts” section. After clicking the symbol choose the \u201cScatter with Smooth Lines and Markers\u201d representing the relationship between the data sets, outlined in Red below.<\/p>\n
![\"Make](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Make-Scatter-Plot-15.png\")
<\/p>\nThe Scatter with Smooth Lines and Markers is created, as seen in the picture below.<\/p>\n
![\"Make](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Make-Scatter-Plot-16.png\")
<\/p>\n7. Scatter Plot with Straight Lines and Markers<\/strong><\/h2>\n
Procedure of creating a Scatter Plot with Straight Lines and Markers in Excel:<\/strong><\/p>\n
Step 1: <\/strong>Select the entire dataset.<\/p>\n
![\"Make](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Make-Scatter-Plot-17.png\")
<\/p>\nStep 2:<\/strong> Go to the \u201cInsert\u201d tab, click \u201cScatter Plot\u201d symbol under “Charts” section. After clicking the symbol choose the \u201cScatter with Straight Lines and Markers\u201d representing the relationship between the data sets, outlined in Red below<\/p>\n
![\"Make](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Make-Scatter-Plot-18.png\")
<\/p>\nThe Scatter with Straight Lines and Markers is created, as seen in the picture below.<\/p>\n
![\"Make](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Make-Scatter-Plot-19.png\")
<\/p>\n8. Create Bubble Chart in Excel<\/strong><\/h2>\n
Procedure of creating a simple <\/strong>Bubble Chart or Bubble Plot <\/strong>in Excel:<\/strong><\/p>\n
Step 1: <\/strong>Select the entire dataset. In this situation, the range of data is A1:C8.<\/p>\n
![\"Make](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Make-Scatter-Plot-20.png\")
<\/p>\nStep 2:<\/strong> Go to the \u201cInsert\u201d tab, click \u201cScatter Plot\u201d symbol under “Charts” section. After clicking the symbol choose the \u201cBubble\u201d plot representing the relationship between the data sets, outlined in Red below.<\/p>\n
![\"Make](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Make-Scatter-Plot-21.png\")
<\/p>\nThe Bubble Chart or Bubble Plot is created, as seen in the picture below<\/p>\n
![\"Make](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Make-Scatter-Plot-22.png\")
<\/p>\nThe size of bubbles determines the value of \u201cNumber of Products Sold\u201d.<\/p>\n
9. How to add trendline in Scatter Plot Chart?<\/strong><\/h2>\n
You may learn how to add a trendline to an Excel Scatter Plot chart. By utilizing this example, I will demonstrate this.<\/p>\n
![\"Make](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Make-Scatter-Plot-23.png\")
<\/p>\nProcedure of adding trendline in Scatter Plot Chart:<\/strong><\/p>\n
Step 1:<\/strong> Select the Scatter Plot Chart. On the right side of the chart, click the Add button. Next, select \u201cMore Options\u201d by clicking the arrow next to \u201cTrendline\u201d.<\/p>\n
![\"Make](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Make-Scatter-Plot-24.png\")
<\/p>\nStep 2:<\/strong> A pane called Format Trendline displays. Decide on the Trend\/Regression type. Toggle Linear. Choose how many periods to include in the prediction. In the Forward box, enter 3. Ensure that both “Display Equation on Chart” and “Display R-squared value on Chart” are checked.<\/p>\n
![\"Make](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Make-Scatter-Plot-25.png\")
<\/p>\nThe result looks like below.<\/p>\n
![\"Make](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Make-Scatter-Plot-26.png\")
<\/p>\nExplanation:<\/strong> Excel uses the least squares approach to determine which line fits the points the best. R-squared = 0.9265, which indicates a strong fit. The line fits the data more accurately the closer it is to 1. Maximum temperature 44\u02da Celsius is anticipated by the trendline for period 12. The equation can be used to prove this. y = 1.0883*12+30.917= 43.91.<\/p>\n
Application of Make Scatter Plot in Excel<\/strong><\/h2>\n
\n\n\n\n\n\n\n\n- \n
- Trend Analysis<\/strong>: Utilize scatter plots to identify relationships and trends between two sets of data, helping to understand how one variable affects another.<\/li>\n
- Outlier Detection<\/strong>: Employ scatter plots to visually detect outliers in your data, which can indicate errors or unique, significant occurrences that require further investigation.<\/li>\n
- Cluster Identification<\/strong>: Use scatter plots to identify clusters of data points, which can help in market segmentation, demographic analysis, or understanding group behaviors.<\/li>\n
- Predictive Modeling<\/strong>: Leverage scatter plots to lay the groundwork for predictive models by visually assessing the linear or non-linear relationships between variables.<\/li>\n
- Scientific Data Examination<\/strong>: Apply scatter plots for analyzing scientific data, such as examining the relationship between temperature and humidity, or other dependent and independent variables.<\/li>\n
- Performance Comparison<\/strong>: Create scatter plots to compare the performance metrics of different entities, such as sales figures versus advertising spend for multiple products.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n
<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\nYou may be interested:<\/p>\n
- \n
- Financial Dashboards<\/a><\/li>\n
- Sales Dashboards<\/a><\/li>\n
- HR Dashboards<\/a><\/li>\n
- Data Visualization Charts<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
Make Scatter Plot in Excel to unlock the full potential of your data analysis. This powerful tool allows you to visualize complex datasets, identify underlying trends, and pinpoint outliers with ease. By integrating scatter plots into your Excel toolkit, you can enhance your understanding of variable relationships, improve your decision-making processes, and present your findings […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[353],"tags":[352,354],"class_list":["post-2716","post","type-post","status-publish","format-standard","hentry","category-make-scatter-plot","tag-make-scatter-plot","tag-make-scatter-plot-in-excel"],"_links":{"self":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/2716","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/comments?post=2716"}],"version-history":[{"count":5,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/2716\/revisions"}],"predecessor-version":[{"id":8683,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/2716\/revisions\/8683"}],"wp:attachment":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/media?parent=2716"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/categories?post=2716"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/tags?post=2716"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- Sales Dashboards<\/a><\/li>\n
- Outlier Detection<\/strong>: Employ scatter plots to visually detect outliers in your data, which can indicate errors or unique, significant occurrences that require further investigation.<\/li>\n
- Trend Analysis<\/strong>: Utilize scatter plots to identify relationships and trends between two sets of data, helping to understand how one variable affects another.<\/li>\n
- Scatter Plot in Excel \u2013 when You Should Use It<\/strong><\/a><\/li>\n