# How to Create Scatter Plot in Google Sheets: A Quick Guide

Published: December 16, 2023 - 3 min read

Hannah Recker

Scatter plots are invaluable for business analysts, revealing insights into relationships between different business metrics. Google Sheets offers a straightforward way to create these plots.

This guide will walk you through creating a scatter plot, using a relatable business operations example: correlating marketing spend with sales revenue.

## Understanding Scatter Plots

### Basics of Scatter Plots

A scatter plot is a type of graphical representation that displays data points on a two-dimensional graph. Each point represents an observation of two variables, one on the horizontal axis (X) and the other on the vertical axis (Y).

Scatter plots help recognize and understand patterns, trends, and correlations between the two variables, making them a useful tool for data analysis.

### Scatter Plots vs Other Charts

Scatter plots have some key differentiators from other types of charts:

• Pattern Recognition: Scatter plots are particularly useful for identifying patterns, trends, or outliers in data. This is in contrast to other charts like bar or line graphs, which primarily depict changes or trends over time.
• Correlation Assessment: One of the main advantages of scatter plots is their ability to display the relationship between two variables. This may not be easily discernible in other chart types, such as pie charts or bar graphs.
• Multiple Levels of Data: Scatter plots can also display multiple levels of data with different shapes, sizes, or colors, offering a comprehensive view of complex datasets, whereas other chart types may only depict a single layer of information.

## How to Create Scatter Plots in Google Sheets

### Setting up Data

Before creating a scatter plot in Google Sheets, ensure that your data is properly formatted. Scatter plots require two columns of data, one representing the x-axis and the other representing the y-axis.

For example, consider the table below, which depicts how marketing investments impact sales.

### Inserting a Scatter Plot

Click the Insert menu at the top left of the window.

Select Chart from the drop-down list.

Initially, Google Sheets might display a different type of chart, like a bar chart.

To change this, follow these steps:

Supercharge your spreadsheets with GPT-powered AI tools for building formulas, charts, pivots, SQL and more. Simple prompts for automatic generation.

In the Chart editor panel that appears on the right side of the screen, click the Chart type dropdown.

Choose Scatter chart from the list of options

Now, your scatter plot should appear on the sheet, displaying the data points according to the values you provided.

### Customizing the Scatter Plot

You can customize your scatter plot to provide additional insights and clarity.

The Chart editor panel offers several options to modify the appearance and functionality of your scatter plot:

• Customize → Chart style: Change the plot’s background color, font, and overall appearance.
• Customize → Chart & axis titles: Edit the chart title, axis titles, and their respective styles (size, format, and color).
• Customize → Series: Modify the point shape, size, and color for each data series.

## Conclusion

Scatter plots in Google Sheets are powerful tools for business analysis. By following these steps, you can create meaningful visualizations to inform your business strategies.

## Try the Spreadsheet Automation Tool Over 350,000 Professionals are Raving About

Tired of spending endless hours manually pushing and pulling data into Google Sheets? Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading spreadsheet automation tool trusted by over 350,000 professionals worldwide.

Sync data from your CRM, database, ads platforms, and more into Google Sheets in just a few clicks. Set it on a refresh schedule. And, use AI to write formulas and SQL, or build charts and pivots.

Hannah Recker Growth Marketer
Hannah Recker was a data-driven growth marketer before partying in the data became a thing. In her 12 years experience, she's become fascinated with the way data enablement amongst teams can truly make or break a business. This fascination drove her to taking a deep dive into the data industry over the past 4 years in her work at StreamSets and Coefficient.
350,000+ happy users
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 20,000 Companies