How to Make a Scatter Plot in Google Sheets

How to Make a Scatter Plot in Google Sheets

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:

  1. 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 Cells
    Select the cells you want to convert into Scatter Plot.

  2. From the top-level Insert menu, select the Chart option.

    Choose the Chart option.

  3. You will notice a chart on the spreadsheet.

    Scatter Plot
    Scatter Plot from the selected range.

  4. On the right-hand side of the sheet, the Chart editor will open. Make sure you select Scatter chart as the “Chart type.”
    Chart Type
    Select Scatter chart as your Chart type.

    Your scatter plot will automatically be added according to your selected data.

Phoebe is an HR assistant in her day job, but is also a web blogger that loves writing guides and sharing her experiences. When she is not out with her friends, she enjoys traveling or binge-watching Netflix. She graduated with a BA in Communication and Media Studies from the University of Utah, and is a chief editor at TechObservatory.

Leave a Comment