{"id":34887,"date":"2021-07-13T14:31:32","date_gmt":"2021-07-13T09:01:32","guid":{"rendered":"https:\/\/trumpexcel.com\/?p=34887"},"modified":"2026-04-26T11:15:25","modified_gmt":"2026-04-26T05:45:25","slug":"scatter-plot-excel","status":"publish","type":"post","link":"https:\/\/trumpexcel.com\/scatter-plot-excel\/","title":{"rendered":"How to Make a Scatter Plot in Excel (XY Chart)"},"content":{"rendered":"\n<p>Excel has some useful chart types that can be used to plot data and show analysis.<\/p>\n\n\n\n<p>A common scenario is where you want to plot X and Y values in a chart in Excel and show how the two values are related.<\/p>\n\n\n\n<p>This can be done by using a <strong>Scatter chart in Excel<\/strong>.<\/p>\n\n\n\n<p>For example, if you have the Height (X value) and Weight (Y Value) data for 20 students, you can plot this in a scatter chart and it will show you how the data is related.<\/p>\n\n\n\n<p>Below is an example of a Scatter Plot in Excel (also called the XY Chart):<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"501\" height=\"301\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Scatter-chart-example.png\" alt=\"Scatter chart example\" class=\"wp-image-35785\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Scatter-chart-example.png 501w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Scatter-chart-example-499x300.png 499w\" sizes=\"(max-width: 501px) 100vw, 501px\" \/><\/figure>\n<\/div>\n\n\n<p>In this tutorial, I will show you how to make a scatter plot in Excel, the different types of scatter plots, and how to customize these charts.<\/p>\n\n\n\n\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">This Tutorial Covers:<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/trumpexcel.com\/scatter-plot-excel\/#What-is-a-Scatter-Chart-and-When-To-Use-It\" >What is a Scatter Chart and When To Use It?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/trumpexcel.com\/scatter-plot-excel\/#Creating-a-Scatter-Plot-in-Excel\" >Creating a Scatter Plot in Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/trumpexcel.com\/scatter-plot-excel\/#Adding-a-Trend-Line-to-the-Scatter-Chart\" >Adding a Trend Line to the Scatter Chart<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/trumpexcel.com\/scatter-plot-excel\/#Identifying-Clusters-using-Scatter-Chart-Practical-Examples\" >Identifying Clusters using Scatter Chart (Practical Examples)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/trumpexcel.com\/scatter-plot-excel\/#Different-Types-of-Scatter-Plots-in-Excel\" >Different Types of Scatter Plots in Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/trumpexcel.com\/scatter-plot-excel\/#Customizing-Scatter-Chart-in-Excel\" >Customizing Scatter Chart in Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/trumpexcel.com\/scatter-plot-excel\/#Adding-Removing-Chart-Elements\" >Adding \/ Removing Chart Elements<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/trumpexcel.com\/scatter-plot-excel\/#Axes\" >Axes<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/trumpexcel.com\/scatter-plot-excel\/#Axis-Title\" >Axis Title<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/trumpexcel.com\/scatter-plot-excel\/#Chart-Title\" >Chart Title<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/trumpexcel.com\/scatter-plot-excel\/#Data-Labels\" >Data Labels<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/trumpexcel.com\/scatter-plot-excel\/#Error-Bars\" >Error Bars<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/trumpexcel.com\/scatter-plot-excel\/#Gridlines\" >Gridlines<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/trumpexcel.com\/scatter-plot-excel\/#Legend\" >Legend<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/trumpexcel.com\/scatter-plot-excel\/#Trendline\" >Trendline<\/a><\/li><\/ul><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/trumpexcel.com\/scatter-plot-excel\/#3D-Scatter-Plot-in-Excel-are-best-avoided\" >3D Scatter Plot in Excel (are best avoided)<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What-is-a-Scatter-Chart-and-When-To-Use-It\"><\/span>What is a Scatter Chart and When To Use It?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Scatter charts are used to understand the correlation (relatedness) between two <a href=\"https:\/\/trumpexcel.com\/one-variable-data-table-in-excel\/\">data variables<\/a>.<\/p>\n\n\n\n<p>A scatter plot has dots where each dot represents two values (X-axis value and Y-axis value) and based on these values these dots are positioned in the chart.<\/p>\n\n\n\n<p>A real-life example of this could be the marketing expense and the revenue of a group of companies in a specific industry.<\/p>\n\n\n\n<p>When we plot this data (Marketing Expense vs. Revenue) in a scatter chart, we can analyze how strongly or loosely these two variables are connected.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Also read: <a href=\"https:\/\/trumpexcel.com\/bell-curve\/\" data-type=\"post\" data-id=\"22268\">Bell Curve in Excel<\/a><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Creating-a-Scatter-Plot-in-Excel\"><\/span>Creating a Scatter Plot in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Suppose you have a dataset as shown below and you want to create a scatter plot using this data.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"449\" height=\"371\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Dataset-for-Scatter-chart.png\" alt=\"Dataset for Scatter chart\" class=\"wp-image-35787\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Dataset-for-Scatter-chart.png 449w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Dataset-for-Scatter-chart-363x300.png 363w\" sizes=\"(max-width: 449px) 100vw, 449px\" \/><\/figure>\n<\/div>\n\n\n<p>The aim of this chart is to see whether there is any correlation between the marketing budget and the revenue or not.<\/p>\n\n\n\n<p>For making a scatter plot, it&#8217;s important to have both the values (of the two variables that you want to plot in the scatter chart) in two separate columns.<\/p>\n\n\n\n<p>The column on the left (Marketing Expense column in our example) would be plotted on the X-Axis and the Revenue would be plotted on the Y-Axis.  <\/p>\n\n\n\n<p>Below are the steps to insert a scatter plot in Excel:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Select the columns that have the data (excluding column A)<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"450\" height=\"373\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Select-the-columns-with-data.png\" alt=\"Select the columns with data\" class=\"wp-image-35786\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Select-the-columns-with-data.png 450w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Select-the-columns-with-data-362x300.png 362w\" sizes=\"(max-width: 450px) 100vw, 450px\" \/><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li>Click the Insert option<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"466\" height=\"223\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Click-the-Insert-tab.png\" alt=\"Click the Insert tab\" class=\"wp-image-35777\"\/><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li>In the Chart group, click on the Insert Scatter Chart icon<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"631\" height=\"223\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Click-on-the-Scatter-chart-icon-in-the-ribbon.png\" alt=\"Click on the Scatter chart icon in the ribbon\" class=\"wp-image-35781\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Click-on-the-Scatter-chart-icon-in-the-ribbon.png 631w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Click-on-the-Scatter-chart-icon-in-the-ribbon-600x212.png 600w\" sizes=\"(max-width: 631px) 100vw, 631px\" \/><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\" start=\"4\">\n<li>Click on the &#8216;Scatter chart&#8217; option in the charts thats show up<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"265\" height=\"549\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Click-on-the-scatter-chart-option-in-the-drop-down.png\" alt=\"Click on the scatter chart option in the drop down\" class=\"wp-image-35776\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Click-on-the-scatter-chart-option-in-the-drop-down.png 265w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Click-on-the-scatter-chart-option-in-the-drop-down-145x300.png 145w\" sizes=\"(max-width: 265px) 100vw, 265px\" \/><\/figure>\n<\/div>\n\n\n<p>The above steps would insert a scatter plot as shown below in the worksheet.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"501\" height=\"301\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Scatter-chart-example.png\" alt=\"Scatter chart example\" class=\"wp-image-35785\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Scatter-chart-example.png 501w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Scatter-chart-example-499x300.png 499w\" sizes=\"(max-width: 501px) 100vw, 501px\" \/><\/figure>\n<\/div>\n\n\n<p>The column on the left (Marketing Expense column in our example) would be plotted on the X-Axis and the Revenue would be plotted on the Y-Axis. It&#8217;s best to have the independent metric in the left column and the one for which you need to find the correlation in the column on the right.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Adding-a-Trend-Line-to-the-Scatter-Chart\"><\/span>Adding a Trend Line to the Scatter Chart<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>While I will cover more ways to customize the scatter plot in Excel later in this tutorial, one thing that you can do immediately after building the scatter plot is to <a href=\"https:\/\/trumpexcel.com\/trendline\/\" target=\"_blank\" data-type=\"post\" data-id=\"27505\" rel=\"noreferrer noopener\">add a trend line<\/a>.<\/p>\n\n\n\n<p>It helps you quickly get a sense of whether the data is positively or negatively correlated, and how tightly\/loosely correlated it is.<\/p>\n\n\n\n<p>Below are the steps to add a trendline to a scatter chart in Excel:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Select the Scatter plot (where you want to add the trendline)<\/li>\n\n\n\n<li>Click the Chart Design tab. This is a contextual tab which only appears when you select the chart<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"393\" height=\"222\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Click-the-Chart-Design-tab.png\" alt=\"Click the Chart Design tab\" class=\"wp-image-35789\"\/><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li>In the Chart Layouts group, click on the &#8216;Add Chart Element&#8217; option<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"486\" height=\"222\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Click-on-Add-Chart-Element-option.png\" alt=\"Click on Add Chart Element option\" class=\"wp-image-35790\"\/><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\" start=\"4\">\n<li>Go to the &#8216;Trendline&#8217; option and then click on &#8216;Linear&#8217;<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"460\" height=\"773\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Click-on-Linear-trendline-option.png\" alt=\"Click on Linear trendline option\" class=\"wp-image-35792\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Click-on-Linear-trendline-option.png 460w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Click-on-Linear-trendline-option-179x300.png 179w\" sizes=\"(max-width: 460px) 100vw, 460px\" \/><\/figure>\n<\/div>\n\n\n<p>The above steps would add a linear trendline to your scatter chart.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"499\" height=\"300\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Scatter-chart-with-trendline.png\" alt=\"Scatter chart with trendline\" class=\"wp-image-35791\"\/><figcaption class=\"wp-element-caption\">Scatter chart with a linear trendline (dotted line)<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Just by looking at the trendline and the data points plotted in the scatter chart, you can get a sense of whether the data is positively correlated, negatively correlated, or not correlated. <\/p>\n\n\n\n<p>In our example, we see a <a href=\"https:\/\/trumpexcel.com\/find-slope-excel\/\" target=\"_blank\" data-type=\"post\" data-id=\"35913\" rel=\"noreferrer noopener\">positive slope in the trendline<\/a> indicating that the data is positively correlated. This means that when the marketing expenses go up then the revenue goes up and if the marketing expenses go down then the revenue goes down.<\/p>\n\n\n\n<p>In case the data is negatively correlated, then there would be an inverse relation. In that case, if the marketing expenses go up then the revenue would go down and vice versa.<\/p>\n\n\n\n<p>And then there is a case where there is no correlation. In this case, when the marketing expenses increase, their revenue may or may not increase.<\/p>\n\n\n\n<p>Note that the slope only tells us whether the data is positively or negatively correlated. it doesn&#8217;t tell us how closely it&#8217;s related.<\/p>\n\n\n\n<p>For example, in our example, by looking at the trendline we cannot say how much the revenue will go up when the marketing expense increases by 100%. This is something that can be calculated using the correlation coefficient.<\/p>\n\n\n\n<p>You can find that using the below formula:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=CORREL(B2:B11,C2:C11)<\/pre>\n\n\n\n<p>The <a href=\"https:\/\/trumpexcel.com\/correlation-coefficient-excel\/\" target=\"_blank\" data-type=\"post\" data-id=\"35052\" rel=\"noreferrer noopener\">correlation coefficient<\/a> varies between -1 and 1, where 1 would indicate a perfectly positive correlation and -1 would indicate a perfectly negative correlation<\/p>\n\n\n\n<p>In our example, it returns 0.945, indicating that these two variables have a high positive correlation.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Identifying-Clusters-using-Scatter-Chart-Practical-Examples\"><\/span>Identifying Clusters using Scatter Chart (Practical Examples)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>One of the ways I used to use scatter charts in my work as a financial analyst was to identify clusters of data points that exhibit a similar kind of behavior.<\/p>\n\n\n\n<p>This usually works well when you have a diverse data set with less overall correlation.<\/p>\n\n\n\n<p>Suppose you have a data set as shown below, where I have 20 companies with their revenue and profit margin numbers.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"380\" height=\"528\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Datset-for-quandrant-wise-scatter-chart.png\" alt=\"Dataset for quadrant wise scatter chart\" class=\"wp-image-35794\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Datset-for-quandrant-wise-scatter-chart.png 380w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Datset-for-quandrant-wise-scatter-chart-216x300.png 216w\" sizes=\"(max-width: 380px) 100vw, 380px\" \/><\/figure>\n<\/div>\n\n\n<p>When I create a scatterplot for this data, I get something as shown below:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"501\" height=\"300\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Scatter-chart-that-can-be-analyzed-quadrant-wise.png\" alt=\"Scatter chart that can be analyzed quadrant wise\" class=\"wp-image-35795\"\/><\/figure>\n<\/div>\n\n\n<p>In this chart, you can see that the data points are all over the place and there is a very low correlation.<\/p>\n\n\n\n<p>While this chart doesn&#8217;t tell us much, one way you can use it to identify clusters in the four quadrants in the chart.<\/p>\n\n\n\n<p>For example, the data point in the bottom left quadrant are those companies where the revenue is low and the net profit margin is low, and the companies in the bottom right quadrant are those where the revenue is high but the net profit margin is low.<\/p>\n\n\n\n<p>This used to be one of the highly discussed charts in the management meeting when we used to identify prospective customers based on their financial data.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Different-Types-of-Scatter-Plots-in-Excel\"><\/span>Different Types of Scatter Plots in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Apart from the regular scatter chart that I have covered above, you can also create the following scatter plot types in Excel:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Scatter with Smooth Lines<\/li>\n\n\n\n<li>Scatter with Smooth Lines and Markers<\/li>\n\n\n\n<li>Scatter with Straight Lines<\/li>\n\n\n\n<li>Scatter with Straight Lines and Markers<\/li>\n<\/ul>\n\n\n\n<p>All these four above scatter plots are suitable when you have fewer data points and when you&#8217;re plotting two series in the chart.<\/p>\n\n\n\n<p>For example, suppose you have the Marketing Expense vs Revenue data as shown below and you want to plot a scatter with smooth lines chart.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"449\" height=\"371\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Dataset-for-Scatter-chart.png\" alt=\"Dataset for Scatter chart\" class=\"wp-image-35787\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Dataset-for-Scatter-chart.png 449w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Dataset-for-Scatter-chart-363x300.png 363w\" sizes=\"(max-width: 449px) 100vw, 449px\" \/><\/figure>\n<\/div>\n\n\n<p>Below are the steps to do this:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Select the dataset (excluding the company name column)<\/li>\n\n\n\n<li>Click the Insert tab<\/li>\n\n\n\n<li>In the Charts group, click on the Insert Scatter Chart option<\/li>\n\n\n\n<li>Click on Scatter with Smooth Lines and Markers options<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"387\" height=\"550\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Scatter-chart-smooth-line-and-markers.png\" alt=\"Scatter chart smooth line and markers\" class=\"wp-image-35796\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Scatter-chart-smooth-line-and-markers.png 387w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Scatter-chart-smooth-line-and-markers-211x300.png 211w\" sizes=\"(max-width: 387px) 100vw, 387px\" \/><\/figure>\n<\/div>\n\n\n<p>You will see something as shown below.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"500\" height=\"301\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Scatter-chart-result-with-smooth-line-and-marker.png\" alt=\"Scatter chart result with smooth line and marker\" class=\"wp-image-35797\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Scatter-chart-result-with-smooth-line-and-marker.png 500w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Scatter-chart-result-with-smooth-line-and-marker-498x300.png 498w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/figure>\n<\/div>\n\n\n<p>This chart can quickly become unreadable if you have more data points. This is why it is recommended to use this with fewer data points only.<\/p>\n\n\n\n<p>I have never used this chart in my work as I don&#8217;t think it gives any meaningful insight (since we can&#8217;t plot more data points to it).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Customizing-Scatter-Chart-in-Excel\"><\/span>Customizing Scatter Chart in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Just like any other chart in Excel, you can easily customize the scatter plot.<\/p>\n\n\n\n<p>In this section, I will cover some of the customizations you can do with a scatter chart in Excel:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Adding-Removing-Chart-Elements\"><\/span>Adding \/ Removing Chart Elements<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>When you click on the scatter chart, you will see plus icon at the top right part of the chart.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"356\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Plus-icon-in-the-scatter-chart.png\" alt=\"Plus icon in the scatter chart\" class=\"wp-image-35802\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Plus-icon-in-the-scatter-chart.png 600w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Plus-icon-in-the-scatter-chart-506x300.png 506w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/figure>\n<\/div>\n\n\n<p>When you click on this plus icon, it will show you options that you can easily add or remove from your scatter chart.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"701\" height=\"335\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Additional-options-that-show-up-when-clicking-on-the-plus-icon.png\" alt=\"Additional options that show up when clicking on the plus icon\" class=\"wp-image-35804\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Additional-options-that-show-up-when-clicking-on-the-plus-icon.png 701w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Additional-options-that-show-up-when-clicking-on-the-plus-icon-600x287.png 600w\" sizes=\"(max-width: 701px) 100vw, 701px\" \/><\/figure>\n<\/div>\n\n\n<p>Here are the options that you get:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Axes<\/li>\n\n\n\n<li><a href=\"https:\/\/trumpexcel.com\/add-axis-titles-in-charts-excel\/\" target=\"_blank\" rel=\"noopener\">Axis Title<\/a><\/li>\n\n\n\n<li>Chart Title<\/li>\n\n\n\n<li>Data Labels<\/li>\n\n\n\n<li>Error Bars<\/li>\n\n\n\n<li>Gridlines<\/li>\n\n\n\n<li>Legend<\/li>\n\n\n\n<li>Trendlines<\/li>\n<\/ul>\n\n\n\n<p>Some of these options are already present in your chart, and you can remove these elements by clicking on the checkbox next to the option (or add these by clicking the checkbox if not checked already). <\/p>\n\n\n\n<p>For example, if  I want to remove the Chart Title, I can simply uncheck the option and it would be gone,<\/p>\n\n\n\n<p>In case you need more control, you can click on the little black arrow that appears when you hover the cursor hover over any of the options.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"302\" height=\"290\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Black-triangle-to-get-more-options-in-the-chart.png\" alt=\"Black triangle to get more options in the chart\" class=\"wp-image-35800\"\/><\/figure>\n<\/div>\n\n\n<p>Clicking on it will give you more options for that specific chart element (these open as a pane on the right side).<\/p>\n\n\n\n<p class=\"has-background\" style=\"background-color:#f8f8c4\">Note: All the screenshots I have shown you are from a recent version of Excel (Microsoft 365). In case you&#8217;re using an older version, you can get the same options when you right-click on any of the chart elements and click on the Format option.<\/p>\n\n\n\n<p>Let&#8217;s quickly go through these elements and some of the awesome customizations you can do to scatter charts using it.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Axes\"><\/span>Axes<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Axes are the vertical and horizontal values that you see right next to the chart.<\/p>\n\n\n\n<p>One of the most useful customizations you can do with axes is to adjust the maximum and minimum value it can show.<\/p>\n\n\n\n<p>To change this, right-click on the axes in the chart and then click on Format axes. This will open the Format Axis pane.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"599\" height=\"393\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Right-click-on-axes-and-and-then-click-on-format-axis.png\" alt=\"Right click on axes and and then click on format axis\" class=\"wp-image-35803\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Right-click-on-axes-and-and-then-click-on-format-axis.png 599w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Right-click-on-axes-and-and-then-click-on-format-axis-457x300.png 457w\" sizes=\"(max-width: 599px) 100vw, 599px\" \/><\/figure>\n<\/div>\n\n\n<p>In the Axis option, you can set the minimum and maximum bounds as well as the major and minor units.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"500\" height=\"598\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Format-Axis-options.png\" alt=\"Format Axis options\" class=\"wp-image-35801\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Format-Axis-options.png 500w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Format-Axis-options-251x300.png 251w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/figure>\n<\/div>\n\n\n<p>In most cases, you can set this to automatic, and Excel will take care of it based on the dataset. But in case you want specific values, you can change them from here.<\/p>\n\n\n\n<p>One example could be when you don&#8217;t want the minimum value in the Y-axis to be 0, but something else (say 1000). Changing the lower bound to 1000 will adjust the chart so that the minimum value in the vertical axis would then be 1000.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Axis-Title\"><\/span>Axis Title<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>The Axis title is something you can use to specify what the X and Y-axis represent in the scatter chart in Excel.<\/p>\n\n\n\n<p>In our example, it would be the Net Income for the X-axis and Marketing Expense for the Y-axis.<\/p>\n\n\n\n<p>You can choose to not show any axis title, and you can remove these by selecting the chart, clicking on the plus icon, and then unchecking the box for Axis title.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"319\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Axis-Title-checked-to-show-axis-title-in-the-chart.png\" alt=\"Axis Title checked to show axis title in the chart\" class=\"wp-image-35805\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Axis-Title-checked-to-show-axis-title-in-the-chart.png 700w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Axis-Title-checked-to-show-axis-title-in-the-chart-600x273.png 600w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/figure>\n<\/div>\n\n\n<p>To change the text in the axis title, simply double-click on it and then type whatever you want as the axis title.<\/p>\n\n\n\n<p>You can also link the Axis title value to a cell.<\/p>\n\n\n\n<p>For example, if you want the value in cell B1 to show up in the vertical axis title, click on the axis title box and then enter =B1 in the formula bar. This will show the value in cell B1 in the axis title.<\/p>\n\n\n\n<p>You can do the same for the horizontal axis title and link it to a specific cell. This makes these titles dynamic and if the cell value changes, the axis titles will also change.<\/p>\n\n\n\n<p>If you need more control on formatting the axis titles, click on any axis, right-click and then click on Format Axis Title.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"601\" height=\"412\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Right-click-on-Axis-and-click-on-Format-Axis-title.png\" alt=\"Right click on Axis and click on Format Axis title\" class=\"wp-image-35806\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Right-click-on-Axis-and-click-on-Format-Axis-title.png 601w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Right-click-on-Axis-and-click-on-Format-Axis-title-438x300.png 438w\" sizes=\"(max-width: 601px) 100vw, 601px\" \/><\/figure>\n<\/div>\n\n\n<p>With these options, you can change the fill and border of the title, change the text color, alignment, and rotation.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"400\" height=\"478\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Format-Axis-title-options.png\" alt=\"Format Axis title options\" class=\"wp-image-35807\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Format-Axis-title-options.png 400w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Format-Axis-title-options-251x300.png 251w\" sizes=\"(max-width: 400px) 100vw, 400px\" \/><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Chart-Title\"><\/span>Chart Title<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Just like Axis titles, you can also format the Chart title in a scatter plot in Excel.<\/p>\n\n\n\n<p>A chart title is usually used to describe what the chart is about. For example, I can use &#8216;Marketing Expense Vs Revenue&#8217; as the chart title.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"599\" height=\"361\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Chart-Title-in-the-scatter-chart.png\" alt=\"Chart Title in the scatter chart\" class=\"wp-image-35812\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Chart-Title-in-the-scatter-chart.png 599w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Chart-Title-in-the-scatter-chart-498x300.png 498w\" sizes=\"(max-width: 599px) 100vw, 599px\" \/><\/figure>\n<\/div>\n\n\n<p>If you don&#8217;t want the chart title, you can click and delete it. And in case you don&#8217;t have it, select the chart, click on the plus icon and then check the Chart Title option.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"280\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Chart-Title-in-Chart-options.png\" alt=\"Chart Title in Chart options\" class=\"wp-image-35810\"\/><\/figure>\n<\/div>\n\n\n<p>To edit the text in the Chart title, double-click on the box and manually type the text you want there. And in case you want to make the <a href=\"https:\/\/trumpexcel.com\/dynamic-chart-titles-in-excel\/\" data-type=\"post\" data-id=\"9431\">chart title Dynamic<\/a>, you can click the title box and then type the cell reference or the formula in the formula bar.<\/p>\n\n\n\n<p>To format the chart title, right-click on the Chart Title and then click on the &#8216;Format Chart Title&#8217; option. This will show the Format Chart Title pane on the right.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"359\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Right-click-and-then-click-on-Format-Chart-Title.png\" alt=\"Right click and then click on Format Chart Title\" class=\"wp-image-35811\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Right-click-and-then-click-on-Format-Chart-Title.png 600w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Right-click-and-then-click-on-Format-Chart-Title-501x300.png 501w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/figure>\n<\/div>\n\n\n<p>With these options, you can change the fill and border of the title, change the text color, alignment, and rotation.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"450\" height=\"537\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Format-Chart-Title-options.png\" alt=\"Format Chart Title options\" class=\"wp-image-35809\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Format-Chart-Title-options.png 450w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Format-Chart-Title-options-251x300.png 251w\" sizes=\"(max-width: 450px) 100vw, 450px\" \/><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Data-Labels\"><\/span>Data Labels<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>By default, data labels are not visible when you create a scatter plot in Excel.<\/p>\n\n\n\n<p>But you can easily add and format these.<\/p>\n\n\n\n<p>Do add the data labels to the scatter chart, select the chart, click on the plus icon on the right, and then check the data labels option.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"276\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Data-labels-option-in-scatter-chart.png\" alt=\"Data labels option in scatter chart\" class=\"wp-image-35816\"\/><\/figure>\n<\/div>\n\n\n<p>This will add the data labels that will show the Y-axis value for each data point in the scatter graph.<\/p>\n\n\n\n<p>To format the data labels, right-click on any of the data labels and then click on the \u2018Format Data Labels\u2019 option.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"383\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Right-click-and-format-data-labels.png\" alt=\"Right click and format data labels\" class=\"wp-image-35817\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Right-click-and-format-data-labels.png 600w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Right-click-and-format-data-labels-470x300.png 470w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/figure>\n<\/div>\n\n\n<p>This will open the former data labels pane on the right, and you can customize these using various options listed in the pane.<\/p>\n\n\n\n<p>Apart from the regular formatting such as fill, border, text color, and alignment, you also get some additional label options that you can use.<\/p>\n\n\n\n<p>In the &#8216;Label Contains&#8217; options, you can choose to show both the X-axis and the Y-axis value, instead of just the Y-axis. <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"450\" height=\"537\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Label-contain-options-in-scatter-plot.png\" alt=\"Label contain options in scatter plot\" class=\"wp-image-35814\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Label-contain-options-in-scatter-plot.png 450w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Label-contain-options-in-scatter-plot-251x300.png 251w\" sizes=\"(max-width: 450px) 100vw, 450px\" \/><\/figure>\n<\/div>\n\n\n<p>You can also choose the option &#8216;Value from Cells&#8217;. which will allow you to have data labels that are there in a column in the worksheet (it opens a dialog box when you select this option and you can choose a range of cells whose values would be displayed in the data labels. In our example, I can use this to show company names in the data labels <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"361\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Company-names-as-data-labels.png\" alt=\"Company names as data labels\" class=\"wp-image-35815\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Company-names-as-data-labels.png 600w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Company-names-as-data-labels-499x300.png 499w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/figure>\n<\/div>\n\n\n<p>You can also customize the position of the label and the format in which it&#8217;s shown.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Error-Bars\"><\/span>Error Bars<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>While I have not seen <a href=\"https:\/\/trumpexcel.com\/error-bars-excel\/\" target=\"_blank\" rel=\"noopener\">error bars<\/a> being used in scatter charts, Excel does have an option that allows you to add these error bars for each data point in the scatterplot in Excel.<\/p>\n\n\n\n<p>To add the error bars, select the chart, click on the plus icon, and then check the Error Bars option.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"321\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Error-bars-in-scatter-plot.png\" alt=\"Error bars in scatter plot\" class=\"wp-image-35820\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Error-bars-in-scatter-plot.png 700w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Error-bars-in-scatter-plot-600x275.png 600w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/figure>\n<\/div>\n\n\n<p>And if you want to customize these error bars further, right-click on any of these error bars and then click on the &#8216;Format Error Bars&#8217; option.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"601\" height=\"363\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Format-Error-Bars.png\" alt=\"Format Error Bars\" class=\"wp-image-35819\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Format-Error-Bars.png 601w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Format-Error-Bars-497x300.png 497w\" sizes=\"(max-width: 601px) 100vw, 601px\" \/><\/figure>\n<\/div>\n\n\n<p>This will open the &#8216;Format Error Bars&#8217; pane on the right, where you can customize things such as color, direction, and style of the error bars.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"450\" height=\"537\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Format-Error-Bars-options-in-scatter-plot.png\" alt=\"Format Error Bars options in scatter plot\" class=\"wp-image-35818\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Format-Error-Bars-options-in-scatter-plot.png 450w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Format-Error-Bars-options-in-scatter-plot-251x300.png 251w\" sizes=\"(max-width: 450px) 100vw, 450px\" \/><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Gridlines\"><\/span>Gridlines<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Gridlines are useful when you have a lot of data points on your chart as it allows the reader to quickly understand the position of the data point.<\/p>\n\n\n\n<p>When you create a scatterplot in Excel, gridlines are enabled by default.<\/p>\n\n\n\n<p>You can format these gridlines by right-clicking on any of the gridlines and clicking on the Format Gridlines option.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"360\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Format-Gridlines-options.png\" alt=\"Format Gridlines options\" class=\"wp-image-35822\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Format-Gridlines-options.png 600w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Format-Gridlines-options-500x300.png 500w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/figure>\n<\/div>\n\n\n<p>This will open the Format Gridlines pane on the right way you can change the formatting such as the color, thickness, &nbsp;of the gridline.<\/p>\n\n\n\n<p>Apart from the major gridlines that are already visible when you create the scatter diagram, you can also add minor gridlines.<\/p>\n\n\n\n<p>Between two major gridlines, you can have a few minor gridlines that further improve the readability of the chart in case you have a lot of data points.<\/p>\n\n\n\n<p>To add minor horizontal or vertical gridlines, select the chart, click the plus icon, and hover the cursor over the Gridlines option.<\/p>\n\n\n\n<p>Click the thick black arrow there appears and then check the \u2018Primary Minor Horizontal\u2019 or \u2018Primary Minor Vertical\u2019 option to add the minor gridlines<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"263\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Primary-Minor-gridlines.png\" alt=\"Primary Minor gridlines\" class=\"wp-image-35823\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Primary-Minor-gridlines.png 700w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Primary-Minor-gridlines-600x225.png 600w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Legend\"><\/span>Legend<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>If you have multiple series plotted in the scatter chart in Excel, you can use a legend that would denote what data point refers to what series.<\/p>\n\n\n\n<p>By default, there is no legend when you create a scatter chart in Excel.<\/p>\n\n\n\n<p>To add a legend to the scatter chart, select the chart, click the plus icon, and then check the legend option.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"327\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Check-the-Legend-option-for-scatter-plot.png\" alt=\"Check the Legend option for scatter plot\" class=\"wp-image-35826\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Check-the-Legend-option-for-scatter-plot.png 700w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Check-the-Legend-option-for-scatter-plot-600x280.png 600w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/figure>\n<\/div>\n\n\n<p>To format the legend, right-click on the legend that appears and then click on the \u2018Format Legend\u2019 option.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"701\" height=\"374\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Formt-legend-option.png\" alt=\"Format legend option\" class=\"wp-image-35825\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Formt-legend-option.png 701w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Formt-legend-option-562x300.png 562w\" sizes=\"(max-width: 701px) 100vw, 701px\" \/><\/figure>\n<\/div>\n\n\n<p>In the Format Legend pane that opens up, you can customize the <a href=\"https:\/\/trumpexcel.com\/shortcuts-fill-color-excel\/\" target=\"_blank\" rel=\"noopener\">fill color<\/a>, border, and position of the legend in the chart.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"450\" height=\"300\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2021\/07\/Format-Legend-Options.png\" alt=\"Format Legend Options\" class=\"wp-image-35824\"\/><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Trendline\"><\/span>Trendline<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>You can also add a trendline in the scatter chart that would show whether there is a positive or negative correlation in the data set.<\/p>\n\n\n\n<p>I&#8217;ve already covered how to add a trendline to a scatter chart in Excel in one of the sections above.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3D-Scatter-Plot-in-Excel-are-best-avoided\"><\/span>3D Scatter Plot in Excel (are best avoided)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Unlike a Line chart, Column chart, or Area chart, there is no inbuilt 3D scatter chart in Excel.<\/p>\n\n\n\n<p>While you can use third-party add-ins and tools to do this, I cannot think of any additional benefit that you will get with a 3D scatter chart as compared to a regular 2D scatter chart.<\/p>\n\n\n\n<p>In fact, I recommend staying away from any kind of 3D chart as it has the potential of misrepresenting the data and portions in the chart.<\/p>\n\n\n\n<p>So this is how you can create a scatter plot in Excel and customize it to make it fit your brand and requirements.<\/p>\n\n\n\n<p>I hope you found this tutorial useful.<\/p>\n\n\n\n<p><strong>Other Excel tutorials you may also like:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/trumpexcel.com\/spot-data-point-in-excel-scatter-chart\/\" target=\"_blank\" rel=\"noopener\">How to Spot Data Point in Excel Scatter Chart<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/trumpexcel.com\/kpi-dashboard-in-excel-part-3\/\" target=\"_blank\" rel=\"noopener\">KPI Dashboard in Excel &#8211; Extract List of Companies from the Scatter Chart<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/trumpexcel.com\/pie-chart\/\" target=\"_blank\" rel=\"noopener\">How to Make a PIE Chart in Excel<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/trumpexcel.com\/area-chart\/\" target=\"_blank\" rel=\"noopener\">How to Create an Area Chart in Excel<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/trumpexcel.com\/combination-charts-in-excel\/\" target=\"_blank\" rel=\"noopener\">How to Create Combination Charts in Excel<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/trumpexcel.com\/actual-vs-target-chart-in-excel\/\" target=\"_blank\" rel=\"noopener\">Creating Actual vs Target Chart in Excel<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/trumpexcel.com\/calculate-area-under-curve-excel\/\" target=\"_blank\" rel=\"noreferrer noopener\">Calculate Area Under Curve in an Excel<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Excel has some useful chart types that can be used to plot data and show analysis. A common scenario is where you want to plot X and Y values in a chart in Excel and show how the two values are related. This can be done by using a Scatter chart in Excel. For example, &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Make a Scatter Plot in Excel (XY Chart)\" class=\"read-more button\" href=\"https:\/\/trumpexcel.com\/scatter-plot-excel\/#more-34887\" aria-label=\"Read more about How to Make a Scatter Plot in Excel (XY Chart)\">Read more<\/a><\/p>\n","protected":false},"author":80,"featured_media":35812,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"rank_math_description":"Step-by-step guide to making a scatter plot (XY chart) in Excel. Add trend lines, spot clusters, and pick the right scatter type for your data.","rank_math_title":"","footnotes":""},"categories":[29,7],"tags":[],"class_list":["post-34887","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-charting","category-excel-tips"],"_links":{"self":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/posts\/34887","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/users\/80"}],"replies":[{"embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/comments?post=34887"}],"version-history":[{"count":3,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/posts\/34887\/revisions"}],"predecessor-version":[{"id":48526,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/posts\/34887\/revisions\/48526"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/media\/35812"}],"wp:attachment":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/media?parent=34887"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/categories?post=34887"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/tags?post=34887"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}