Last Updated on
Transform your Excel spreadsheet data into a clean and concise format by converting it into a scatter plot. A scatter plot, otherwise known as a scatter chart or scatter diagram, presents variables along an XY axis to reveal correlations.
Find out how to use Excel to convert spreadsheet data into a convenient scatter plot with our simple guide.
How To Make A Scatter Plot In Excel (Windows PC)
Creating a scatter plot on Microsoft Excel is very simple. Get your tables of data ready and let’s begin. This is how you make a scatter plot on a Windows PC.
Open The Worksheet
Open the worksheet that contains the data you want to plot on your scatter chart. Highlight all the data you wish to be included as this selects the data which will be plotted on your graph.
Insert Scatter (X, Y) Or Bubble Chart
Select the Insert tab, and then click the symbol for Insert Scatter (X, Y) or Bubble Chart. This is in the charts group.
This is when you should select Scatter.
By resting your cursor on the various chart symbols, you can see the name and type. You can also see how the chart is best used, in case you’re struggling to decide how to display information. Now you have Scatter selected, you can begin to format your chart.
Open The Design And Format Tab
To open the Design and Format tab, click on the chart. This will pop up new tabs on the top of your screen. Click on the Design tab, and then select the plot style you want.
Add A Title
To add a title it is very simple. To do so, click on the chart title, then right-click on the title to change the font and size.
Select Add Chart Element
Click on the Design tab again, and select Add Chart Element, and then Axis Titles. From here, you can add a Primary Horizontal title, and a Primary Vertical title. To do so, click on the title, and type in your text.
These titles can be formatted using the Format tab. Click Format, then Chart Elements, then Format Selection. The Format Title box will appear. Select Size & Properties to alter the alignment, direction, and angle.
Select The Format Tab
Select the Format tab, the Charts Elements box, and then Plot Area.
Select Shape Styles
Next, select Shape Styles on the Format tab, and then select the More button to change effects.
Page Layout Tab
Change the theme using the Page Layout tab. Click the Themes group, and then select Themes. Select Office, and find the theme you want.
Different styles of the scatter plot can be used to display various types of information. Experimenting with the scatter options can help you to see which chart style best displays the information you’re presenting.
How To Make A Scatter Plot In Excel (MacOS)
A scatter plot can also be used to display worksheet data using macOS. The method is not vastly different to the Windows version, so without further ado let’s get into this method.
Open The Worksheet
Open the worksheet that contains the data you want to plot on a scatter chart.
Select X Y Scatter
Select all the data you wish to be included in the scatter plot.
Click the Insert tab, and then select X Y Scatter. Under Scatter, pick your chosen chart.
Select The Chart Design Tab
With the scatter plot created, you can begin to edit and design your chart. Select the Chart Design tab to access your options.
- From Chart Design, you can modify the titles, labels, legend, etc. using Add Chart Element.
- Use Quick Layout to select from predefined chart elements.
- In the Style Gallery, you can change the layout and style using previews.
- Adjust the data view using Switch Row/Column or Select Data.
- Use the Design tab to change the shape fill, outline, and effects.
A scatter chart is a clear and efficient way to display data. By converting the data from an Excel worksheet into a scatter plot, it can be easier for users to view and assess correlations. This simple method for converting data to scatter plots can make your spreadsheet easier to read and digest.