# How to Create a 3D Scatter Plot in Excel

Suppose you have the following dataset to use for a 3D Scatter Plot.

### Steps:

• Select the active range (B4:D16 in this example)
• Go to the Insert tab and expand Insert Scatter.

• Click on Scatter to insert a scatter chart.

Steps:

• Right-click on the chart area and choose Select Data from the context menu.

• The Select Data Source window will open.
• Click on the Sales (in Units) series and choose Remove.

• Choose the Revenue (in dollars) series and click on Edit.

• The Edit Series window will pop up.
• Insert the appropriate data and hit OK.

• Click OK.

### Format Data Series in Scatter Chart

Steps:

• Click on a Data Series and press the Ctrl+1 keys.

• The Format Data Series pane will open.
• Click on the Effects icon and expand 3-D Format.

• Click on Top bevel and choose Round.

• Choose Fill & Line and click on Marker
• Expand Marker Options.
• Check Built-in and increase the size.

### Save and Display 3D Scatter Plot

Steps:

• Place the 3D scatter chart in the appropriate location.
• Save the workbook.

### Things to Remember

• Scatter plots show the degree to which variables are correlated.
• The two variables in the scatter chart are X and Y.

What is a 3D plot?

• A 3D plot is a graph that shows data in three dimensions. It allows easier exploration of relationships and patterns.

What is the use of a 3d scatter plot?

• A 3d scatter chart is used to identify clusters and trends and provide deeper insights.

How do you make a scatter plot with 3 Excel data sets?

• Put your data into three separate columns.
• Select all the data and Insert a scatter plot.
• Right-click on Chart Area, and click on Select Data.
• Click Add to add each set of data one by one.

## Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
Lutfor Rahman Shimanto

Lutfor Rahman Shimanto, BSc, Information Technology, Jahangirnagar University, Bangladesh, has worked with the ExcelDemy project for over a year. He has written 50+ articles and provided solutions of 100+ comments for ExcelDemy. Currently, he works as an Excel & VBA Developer and provides support and solutions in the ExcelDemy Forum. He has solved 100+ ExcelDemy Forum problems. His work and learning interests are in developing various Excel & VBA and Desktop applications. Outside of work, he enjoys Chess... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF