How to Create a Scatter Plot in Google Sheets

Gone are the days when we had to make scatter plots manually using graph papers. Thanks to technology, making scatter plots has become a breeze! In this article, I will guide you through the steps to create a scatter plot in Google Sheets.

Step 1: Gathering Data

The first step to creating a scatter plot is to gather data. Make sure you have a set of data points that you want to plot. The data should be organized into two separate columns - one for the x-axis and one for the y-axis. In this example, I will use data from a survey asking people how many cups of coffee they have per day and how many hours of sleep they get per night.

Step 2: Open a Google Sheets Document

To create a scatter plot in Google Sheets, you will need a Google account. If you don't already have an account, go ahead and create one. Once you're signed in, open a new Google Sheets document. Make sure you give your document a name that you'll remember later.

Step 3: Enter Your Data

Now it's time to enter your data into the sheet. Make sure you've labeled your columns with headings that make sense. Enter the x-axis data into one column and the y-axis data into another.

Step 4: Highlight Your Data

Select all of the cells containing your data, including the column headings, by clicking on the top left cell and dragging your cursor to the bottom right cell.

Step 5: Create the Scatter Plot

Click on the "Insert" tab at the top of your screen. A drop-down menu will appear. Select "Chart" from the menu. A new window will appear with all of the different chart options that Google Sheets offers. Select "Chart types" and then "Scatter." Google Sheets should automatically generate a scatter plot based on your data.

Step 6: Customize Your Scatter Plot (Optional)

You can customize your scatter plot to your liking. For example, you can change the colors of your data points, add a title, or adjust the axis labels. Simply click on your chart and select "Customize" from the toolbar. From there, you can play around with different customization options.

Step 7: Save and Share Your Scatter Plot

Finally, it's time to save and share your scatter plot with others. Click on "File" at the top of your screen and select "Download" to save a copy of your chart to your computer. You can also share your scatter plot via email by clicking on the "Share" button in the top right-hand corner of the page.


Creating a scatter plot in Google Sheets is simple and can be done in just a few steps. Whether you're a student trying to complete a homework assignment or a marketer trying to analyze data, scatter plots can help you visualize data more effectively.

By clicking “Accept”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.