Google Sheets lets you visualize data using various techniques, including creating tables and charts. A scatter plot allows you to define trends in a data set and present a linear relationship between two variables. This guide will teach you to make a scatter plot in Google Sheets.
Inserting a Scatter Plot in Google Sheets
Follow the steps below to make a Scatter Plot in Google Sheets:
- Select the data you wish to visualize as a scatter plot. For example, I have selected cells A1:B15.Note: to add axes titles in your chart, add headers to your data.
Select the cells you want to convert into Scatter Plot. - From the top-level Insert menu, select the Chart option.
Choose the Chart option. - You will notice a chart on the spreadsheet.
Scatter Plot from the selected range. - On the right-hand side of the sheet, the Chart editor will open. Make sure you select Scatter chart as the “Chart type.”
Select Scatter chart as your Chart type. Your scatter plot will automatically be added according to your selected data.