How to Create a Scatter Plot with 4 variables in Excel (with Quick Steps)

If you ask me which tool is best for visualizing data, you will always get the same answer from me which is scattered plot. Because you can plot many variables and add different data in this plot. In this article, I am going to share with you how to create a scatter plot with 4 variables in excel.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


3 Simple Steps to Create a Scatter Plot with 4 variables in Excel

A scatter plot is a chart or diagram where the relationship between two or more numeric values can be drawn. It is different from other charts because it plots values on both horizontal and vertical axis. It automatically draws independent variables on the horizontal axis and the dependent variables on the vertical axis which makes it easier to work with. On the other hand line charts and others plot variables on a horizontal axis only.

In the following article, I have described 3 easy and quick steps to create a scatter plot with 4 variables in excel.

Suppose we have a dataset of a shop’s monthly sales of 4 types of products. Now we will make a scatter plot with these 4 different types of products.

Create a Scatter Plot with 4 variables in Excel


1. Insert a Scatter Chart from Dataset

Firstly we will choose the whole dataset to create a scatter plot with 4 variables in excel.

  • Here I have selected cells (B5:F12).

Insert a Scatter Chart from Dataset to Create a Scatter Plot with 4 variables in Excel

  • Select a “Scatter Chart” from the “Insert” option.

  • A scatter chart will be ready with the values from the table.

Insert a Scatter Chart from Dataset to Create a Scatter Plot with 4 variables in Excel

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


Similar Readings


2. Change Series Names According to Dataset

Secondly, we will change the names according to the dataset.

  • While selecting the diagram right-click the mouse button to get options.
  • Choose “Select Data” from the options.

Change Series Names According to Dataset to Create a Scatter Plot with 4 variables in Excel

  • A new window will appear named “Select Data Source”.
  • Choose “Series 1” and click “Edit”.

  • A new window will pop-up asking for the “Series name”.
  • Choose the series name “Sales of Fruits” from the dataset as our first series table consists of data “Sales of Fruits”.
  • Hit the OK button to continue.

Change Series Names According to Dataset to Create a Scatter Plot with 4 variables in Excel

  • Thus name all the series from your data list.
  • Press OK to continue.

Change Series Names According to Dataset to Create a Scatter Plot with 4 variables in Excel

  • Now our scatter diagram will look like the following screenshot.

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


3. Create and Format the Scatter Plot with 4 Variables

This is the last step where we will change format and color according to our choice to create a scatter plot with 4 variables in excel.

  • Select a point from the diagram and right-click the mouse button.
  • Choose “Format Data Series” from the options.

Change Format and Color of the Scatter Plot to Create a Scatter Plot with 4 variables in Excel

  • From the right pane go to “Marker” and press “Built-in”.
  • From the drop-down list of types choose an icon of your choice.

  • This way the points with changed shapes will look like the following.

Change Format and Color of the Scatter Plot to Create a Scatter Plot with 4 variables in Excel

  • To change color open the “Format Data Series” just like the previous steps.
  • Go to “Fill” option and choose a color.

Change Format and Color of the Scatter Plot to Create a Scatter Plot with 4 variables in Excel

  • After removing unnecessary data the final scatter diagram will look like the following screenshot.

Change Format and Color of the Scatter Plot to Create a Scatter Plot with 4 variables in Excel

  • In this final step, we will add lines between the points for better visualization.
  • Choosing points from the data table open the “Format Data Series”.

  • From the “Line” options press “Solid Line”.

Change Format and Color of the Scatter Plot to Create a Scatter Plot with 4 variables in Excel

  • Thus our spreadsheet will draw a line between the points in the chart.

Change Format and Color of the Scatter Plot to Create a Scatter Plot with 4 variables in Excel

  • Now we will draw lines for all 4 variables.
  • This way our final scatter plot will look like the following screenshot.

Change Format and Color of the Scatter Plot to Create a Scatter Plot with 4 variables in Excel

Read More: How to Create Excel Scatter Plot Color by Group (3 Suitable Ways)


Things to Remember

  • If you want to add variables lying in a different position on the spreadsheet, you just have to copy the list and then select the scattered chart. After that go to the paste option and choose the “Paste Special”. This way you can add variables placed in a different location in your worksheet.

Conclusion

In this article, I have tried to cover all the simple methods to show creating a scatter plot with 4 variables in excel. Take a tour of the practice workbook and download the file to practice by yourself. Hope you find it useful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.


Related Articles

Wasim Akram

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo