How To Use Google Sheets To Make A Scatter Plot

To create a scatter plot in google sheets open up a spreadsheet and pick the cells containing your data.

How to use google sheets to make a scatter plot. After this select your data and then open up insert from the top menu and click on the chart icon. With the information selected find insert chart from the menu. Customize a scatter chart on your computer open a spreadsheet in google sheets. This is how a sample data set will look like on the spreadsheet. This will open up the chart editor resource in the ideal hand panel.

Creating a scatter plot in google sheets. Create a new google sheet from google drive to start making the scatter plots. Login to your gmail and click the sheets program from the app menu click the nine dots in the upper right. Enter the values for y axis which usually shows up as a series on the chart. Google usually tries to understand your selected data and displays the chart it thinks is the best representation for it.

First make a new sheets document in google drive to begin making a scatter plot in google sheets and start to insert your data either manually or through import. Google sheets will mechanically attempt to determine what form of chart or graph it really should use. Ideally it should display a scatter chart. This will display a chart on the worksheet and a chart editor sidebar on the right side of the window. This will open the chart editor tool in the right hand panel.

Select the chart option. Then click insert chart initially it ll create a terrible bar chart where each of the 250 rows of data is represented by a bar. To create a scatter plot highlight both columns of data including the header row. To create a scatter plot in google sheets you are going to need a gmail account to use google s spreadsheet program called sheets. At the right click customize.

Start entering the values for x axis and give a column name. Double click the chart you want to change. Google sheets will automatically attempt to determine what type of chart or graph it should use with the selected data.