How to Make a Scatter Plot in Excel 2013

Select the data you want to plot in the scatter chart. Click the Insert tab, and then click Insert Scatter (X, Y) or Bubble Chart. Click Scatter . Tip: You can rest the mouse on any chart type to see its name.

Scatter charts are an important tool in statistics that help to identify a possible relationship between two variables. They are particularly useful in visualizing sales and financial data. If you have data that you want to display on a scatter chart in Excel 2013, this guide will show you how.

First, enter your data into two columns. For example, you could use months as numbers in column A and your sales totals in column B. Select all of your data and click on the Insert tab. Then click the Insert Scatter icon. You will be given a few options to choose from, but for this tutorial, we will use a plain scatter chart.

Once your chart is selected, you will see the Design and Format tabs on the toolbar. You can select a quick layout, such as adding a linear regression line. This line will give you an idea of where the sales are going in the future. You can also add an R-squared correlation coefficient, which tells you how closely your data fits the line. The maximum value for correlation is 1, so if your result is close to 1, there is a good line of fit for your data.

Under Chart Styles, you can change how your chart looks by hovering over different options. On the Format tab, you can change the formatting of different chart elements, such as the color of the trendline. You can also change the type of line to better fit your data. For example, if you have data that looks more exponential than linear, you can change the line to an exponential one.

Aside from formatting options, you can also add comments to your chart. To do this, insert a shape and click the down arrow. Choose the arrow and make a note about any important points. You can also add text boxes to your chart to explain any anomalies or trends.

In conclusion, scatter charts are an important tool in statistics and Excel 2013 makes it easy to create them. With just a few clicks, you can display your data in a way that helps you better understand any relationships that may exist. For more tips and videos on Excel and statistics, visit


How do you do a scatter chart in Excel 2013?
Select all the cells click on Insert, in the Charts grouping, choose Scatter. I chose Scatter with only Markers. It is the first one listed. Hold your mouse over it to find the name of each type of chart.
How do I make a scatter plot with multiple data in Excel?
Highlight the two columns you want to include in your scatter plot. Then, go to the “Insert” tab of your Excel menu bar and click on the scatter plot icon in the “Recommended Charts” area of your ribbon. Select “Scatter” from the options in the “Recommended Charts” section of your ribbon.
How to create a scatter plot in Excel with 2 variables and labels?
On the Insert tab, in the Charts group, click the Scatter symbol.Click Scatter.Result:Note: we added a trendline to clearly see the relationship between these two variables. ... On the Insert tab, in the Charts group, click the Scatter symbol.Click Scatter with Straight Lines.More items...
How to create a scatter plot distribution in Excel?
Step 1: Select the data.Step 2: Go to Insert >, Charts >, Scatter Chart >, Click on the first chart.Step 3: It will insert the chart for you.Step 4: Select the bubble. ... Step 5: Click the Marker Fill option and select Vary Colours by Point.More items...