How to Make a Scatter Plot in Google Sheets 2021.
A scatter plot (also known as a scatter plot) is a useful tool for data analysts to visually explore and analyze two different sets of data. For example, if you are comparing the sales results of different sales teams, then a scatter chart will let you see who is doing the best (or worst), just like a line chart.
While you can use Excel to build a scatterplot. Another way to do it is to use free Google Sheets to build a scatterplot. In this article, we will explain how to create a scatterplot in Google Sheets.
how to customize it after creation.
How to Make a Scatter Plot In Google Sheets
A scatter plot, as the name suggests, uses scattered points across a chart to visualize two or more types of related data. For example, if you want to compare sales and sales profits, a scatter chart (showing profit versus sales revenue) would be ideal, showing the profit and revenue for each salesperson.
If you have two comparable datasets, you can create a scatterplot.
Google Sheets makes it easy with a charting tool.
- To create a scatterplot in Google Sheets, open a spreadsheet and select the cells containing your data. With the data selected, choose Insert> Chart.
- The diagram editor tool will open in the right pane. Google Sheets will automatically try to determine which type of chart or graph to use with the selected data. If a scatter plot is not automatically selected in Google Sheets, select it from the Chart Type drop-down menu in the Options tab. If you don’t know what each chart is, hover over it to give it a title.
- The Chart Editor will use the selected cells to form a range of data for the chart. If you want to change this, click the Select Data Range button (next to the Data Range field). Alternatively.
you can manually enter a range of cells in the Data Range box.
- The inserted diagram will immediately update to the new type. By default, a scatter chart will have x-axis data that links the two forms of data together (for example, sales group names). The series will show two (or more) forms of data that you want to compare (such as profit and revenue). To add additional series, select the Add Series field and select one of the additional datasets.
If you need to remove one of the series, select the hamburger menu icon, then select the Remove option.
- If you want Google Sheets to use the top row to create headings, select the Use row 1 as a headings check box. To use the first column as labels (shown next to the x-axis), select the Use Column A as a labels check box. You can also switch rows and columns by checking the Switch rows/columns box.
Customizing a Scatter Plot
Like all charts and graphs in Google Sheets, the chart editor offers a number of additional customization options. This allows you to change labels, axis titles, colors, fonts, and more.
- To customize the scatter plot, make sure the chart editor pane on the right side is visible. If it doesn’t, select the chart and then select the hamburger menu icon in the upper right corner. From the menu, select the Modify Chart option.
- On the Options tab in the diagram editor menu, you can start making changes to the diagram. To change the colors and fonts of the chart, select the chart style category and select one of the options (for example, background color) to make your changes. Any changes you make will appear automatically.
- In the chart and axis titles, you can change the display titles for the chart and chart axes.
Select a title option from the Chart Title drop-down menu
- then paste the text you want to use in the Title text box. Then you can format the text (including font, formatting, and color) in the options below the box.
By default, data points in a Google Sheets scatterplot appear as circles.
To use a different shape
- (such as triangles or X marks), select the Series category, and then choose a new shape from the Point Shape drop-down menu. You can also choose a new point size from the Point size drop-down menu.
- The legend allows you to determine which dataset the points belong to in the scatter plot. To change the font, formatting, color, and position of the legend, select the Legend category and make your changes using the options provided.
- In the Horizontal Axis and Vertical Axis categories, you can change the label formatting of the various axes. Select any category, then make changes to the font, font size, formatting and color from the options provided. If you want to change the order of the axes (from left to right or from right to left), select the Reverse axis order check box.
- To make the scatter plot more visible, you can add gridlines and elevations. To do this, select the Gridlines and Elevations category, then select either Horizontal Axis or Vertical Axis from the drop-down menu. With the Horizontal Axis option selected, select the Major Elevations check box to enable elevations on the horizontal axis, then make additional adjustments to the settings (including position, length, color, and thickness) below it.
- With the Vertical Axis option selected from the Grid Lines And Elevation menu, you can include grid lines (both major and minor) and elevations for the vertical axis. Select the Major Gridlines, Minor Gridlines, Major Elevations, or Minor Elevations checkboxes to enable these options, then make changes to the settings (including color, position, length, weight, and color) below them.
Create Visual Spreadsheets
Now that you know how to create a scatter chart in Google Sheets, you can also experiment with creating other Google Sheets graphs and charts for data analysis, from line charts to bar charts. If you’re having trouble, there are Google Sheets templates that you can use to get started, ready to populate with data and create your own charts from it.
Advanced Excel users can also easily convert spreadsheets to Google Sheets, although some features (such as Excel macros) are not supported. You can go even further by using Google Sheets scripts to extend functionality and integrate spreadsheets with other Google and third-party services.
How to Make a Scatter Plot in Google Sheets 2021
How to Make a Scatter Plot in Google Sheets 2021.
google sheets scatter plot multiple series
how to make an x y graph in google sheets
scatter plot generator
how to make an x y line graph in google sheets
google sheets scatter plot with lines