How to Create a Scatter Plot in Excel with 3 Variables (with Easy Steps)

 

Step 1 – Arrange the Dataset for a Scatter Plot with 3 Variables

We have a dataset of sales with Month(X) in Column B, Product Price(Y) in Column C, and Items Sold(Z) in Column D.

Step-by-Step Procedures to Create Scatter Plot in Excel with 3 Variables

Read More: How to Make a Scatter Plot in Excel with Multiple Data Sets


Step 2 – Generate Scatter Plot

Steps:

  • Select Column B, Column C, and Column D.
  • Click the Insert tab and go to the Insert Scatter option.
  • Select the first Scatter chart.

Step-by-Step Procedures to Create Scatter Plot in Excel with 3 Variables

  • Excel will insert a scatter chart.

Step-by-Step Procedures to Create Scatter Plot in Excel with 3 Variables

Read More: How to Create a Scatter Plot in Excel with 2 Variables


Step 3 – Apply Different Scatter Plot Types with 3 Variables

Steps:

Apply Different Scatter Plot Types with 3 Variables

  • If you select ‘Scatter with Straight Lines’, the following chart will come up.

Step-by-Step Procedures to Create Scatter Plot in Excel with 3 Variables

Read More: How to Create a Scatter Plot with 4 Variables in Excel


Types of Scatter Graphs and Correlation

Positive Correlation: With the increase in the x variable, the y variable also increases.

Negative Correlation: With the increase in the x variable, the y variable decreases.

No Correlation: If there is no connection between the variables, then the points don’t seem to influence one another. These could be two completely independent variables.


Designing a XY Scatter Plot with 3 Variables in Excel

Method 1 – Adjusting the Axis Scale (Reducing White Space)

Steps:

  • Right-click on the x-axis and go to Format Axis.
  • Set the Minimum and Maximum Bounds as needed.
  • You can change the spacing between the grid lines using the Major and Minor units.

Designing XY Scatter Plot with 3 Variables in Excel


Method 2 – Attaching Labels to Scatter Plot Data Points

Steps:

  • Select the whole chart and click on the Chart Elements option.
  • Check the Data Labels box and then select More Options.

Designing XY Scatter Plot with 3 Variables in Excel

  • Click on the Label Options, choose the Value From Cells option and then go to Data Label Range.
  • In the Select Label Range box, choose the desired column.

Designing XY Scatter Plot in Excel

  • After pressing OK, you will get a result similar to the below.

Designing XY Scatter Plot in Excel


Method 3 – Adding a Trendline and an Equation

Steps:

Designing XY Scatter Plot in Excel

  • You’ll get a Display Equation on the Chart box on the Format Trendline which will come to the right side of your window just after you’ve added a trendline. The result will look similar to this:


Method 4 – Switching the X and Y Axes in a Scatter Chart

Steps:

  • Right-click on either the X or Y-axis and click on Select Data.

Designing XY Scatter Plot in Excel

  • In the Select Data Source dialog box, click Edit.

  • Copy Series X values to the Series Y values box and vice versa. (You’ll need an intermediate point to save one result.)

  • After clicking OK, your scatter plot will show this transformation:


Things to Remember

When two or more data points are very close to each other, their labels can overlap. To fix this, click on the labels and select only the overlapping data. Point your mouse cursor to the selected label and wait until the cursor changes to the four-sided arrow, then drag the label to the desired position.


Download  thePractice Workbook


Related Articles


<< Go Back To Make Scatter Plot in Excel | Scatter Chart in Excel | Excel ChartsLearn Excel

Get FREE Advanced Excel Exercises with Solutions!
Zehad Rian Jim
Zehad Rian Jim

Zehad Rian Jim is a dedicated professional with a BSc. Degree in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. He's good with Microsoft Office and has written more than 80 helpful articles for ExcelDemy in the last year. Now, he makes fun and easy-to-follow Excel tutorials for YouTube as part of the ExcelDemy Video project. Zehad loves figuring out Excel problems, and his passion for learning new things in Excel shines through in... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo