How to Plot Points on a Graph in Google Sheets

Want to turn endless rows of data into a clear visual story? Plotting points on a graph is the perfect way to see the relationship between two sets of numbers, and Google Sheets makes it surprisingly straightforward. This tutorial will walk you through setting up your data, creating a scatter plot in seconds, and customizing it to find the patterns hidden in your numbers.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Start with Tidy Data

Before you even think about creating a chart, the most important step is setting up your data correctly. To plot points, you need at least two columns that work as a pair. Think of them as coordinates on a map, often called an X-Y pair in data terms.

• The X-Axis (Column 1): This is your independent variable. It's the thing you control, measure, or that happens sequentially, like time, spending, or effort.
• The Y-Axis (Column 2): This is your dependent variable. It's the outcome you're measuring to see how it's affected by the X-axis variable.

In simple terms, you're trying to see "how did Y change when X happened?" For your data to work, you need to structure it in two columns, side by side. Add clear headers to the top of each column so you remember what you're looking at.

Here are a few common business examples:

• Marketing: How did daily ad spend (X) affect website clicks (Y)?
• Sales: How many demos (Y) were booked based on the number of cold calls made (X)?
• Content: How much organic traffic (Y) did we get each month this year (X)?

Let’s use a simple example. Imagine we're tracking a new social media campaign. We want to see how the number of posts we make each day (X-axis) impacts the number of new followers we gain (Y-axis). Your data in Google Sheets should look like this:

Posts per Day, New Followers 2, 35 3, 50 1, 15 5, 80 4, 65 2, 40

With clean, two-column data like this, you’re ready to build your graph.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Plot Points: Step-by-Step

Once your data is organized, creating a scatter plot takes less than a minute. This type of chart is ideal for plotting points, as it displays each X-Y data pair as a single dot on the graph, making it easy to spot trends or relationships.

1. Select Your Data

Click and drag your mouse to highlight all the cells containing your data, including the two header cells. Highlighting the headers tells Google Sheets what to label your axes automatically.

2. Insert the Chart

With your data selected, navigate to the top menu and click Insert > Chart. A chart will appear on your spreadsheet, along with a "Chart editor" panel on the right side of your screen.

3. Choose the Scatter Chart Type

Google Sheets does its best to guess which type of chart you want, but it doesn't always get it right. It might default to a line chart or a bar chart. We specifically want a scatter plot to show individual points.

In the Chart editor panel, under the Setup tab, find the "Chart type" dropdown menu. Click on it, scroll down to the "Scatter" section, and select the scatter plot icon. Your chart will instantly update, showing your data points as dots.

And that's it! You've plotted your first set of points. The first column ("Posts per Day") will be plotted along the horizontal X-axis, and the second column ("New Followers") will be plotted along the vertical Y-axis. Now, let's make it look professional.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Customize Your Graph for Maximum Insight

A basic chart shows your data, but a great chart tells a story. The customization options in the Chart Editor are what transform your plot from a simple set of dots into a valuable analytical tool.

Click on your chart, then click the three vertical dots in the top-right corner and choose Edit chart. This will bring back the Chart editor panel if it disappeared. Now, click on the Customize tab.

Add Clear Titles and Labels

An untitled chart is meaningless to anyone looking at it cold. First, go to Chart & axis titles.

• Chart title: Give your graph a descriptive title. Instead of "New Followers," a better title would be "New Followers Gained vs. Daily Social Posts."
• Horizontal axis title: This is your X-axis. Its title will be "Posts per Day."
• Vertical axis title: This is your Y-axis. Its title will be "New Followers Gained."

These titles provide instant context, making your graph understandable at a glance.

Style Your Data Points and Add a Trendline

Next, let's make the data itself clearer. Click on the Series dropdown in the Customize menu.

• Color and Shape: You can change the color of your points to match your branding or make them stand out. You can also change the shape (from a circle to a star, triangle, or square) and the point size. This is especially useful when plotting multiple series, which we'll cover next.
• Trendline: This is one of the most powerful features for a scatter plot. Check the "Trendline" box. Google Sheets will automatically draw a line that best fits the general direction of your data points. This line immediately reveals the relationship in your data. In our example, an upward-sloping trendline confirms our hypothesis: the more we post, the more followers we tend to gain.

Adjust the Gridlines and Axes

Finally, you can clean up the background and scale of your chart for better readability.

• Under Gridlines and ticks, you can adjust the spacing of your axes or add minor gridlines to help guide the eye.
• Under the Horizontal axis and Vertical axis menus, you can manually set minimum and maximum values. This is useful for "zooming in" on data or maintaining a consistent scale across multiple charts.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Plotting More Than One Data Series

What if you want to compare two different social media platforms on the same graph? Plotting multiple sets of points is just as easy.

First, structure your data with a single X-axis column and multiple Y-axis columns. Each Y-axis column represents a different series of data you want to plot.

Posts per Day, Instagram Followers, TikTok Followers 2, 35, 60 3, 45, 90 1, 40, 85 5, 55, 110 4, 60, 125

To plot this, simply select all three columns (including headers) and click Insert > Chart again, choosing the Scatter chart type if needed.

Google Sheets will automatically plot both Instagram Followers and TikTok Followers against the Day axis, giving each platform its own color. Now, two customization options become critical:

• Legend: Under the Customize tab, go to the Legend menu. Here you can position the legend, which is the key that tells viewers what each color represents (e.g., blue dot = Instagram, red dot = TikTok).
• Series Customization: In the Series menu, you'll now see a dropdown that lets you select between "Instagram Followers" and "TikTok Followers." You can apply different formatting - like unique colors, shapes, or even a separate trendline - to each series to make your comparison crystal clear.

Troubleshooting Common Issues

Sometimes your chart might not look quite right on the first try. Here are a few quick fixes to common problems:

• Problem: My points are all connected by lines. Solution: You've accidentally created a Line chart instead of a Scatter plot. In the Chart editor, go to Setup > Chart type and select "Scatter chart."
• Problem: My axes are flipped (X-values are on the Y-axis and vice-versa). Solution: In the Setup tab, you'll see options for "X-axis" and "Series." If they're wrong, you can manually reassign which column applies to which axis, or simply click the "Switch rows / columns" checkbox to swap them instantly.
• Problem: The chart says "No Data" or some points are missing. Solution: Double-check your data range selection. Go to the Setup tab and look at the "Data range" field to ensure you've highlighted all the correct cells and that there aren't any hidden filters or blank rows preventing the data from appearing.

Final Thoughts

Plotting points in Google Sheets is a fundamental skill for anyone working with data. By organizing your data into X-Y pairs, inserting a scatter plot, and using customization tools like titles, labels, and trendlines, you can quickly turn a plain dataset into a compelling visual analysis.

While Google Sheets is fantastic for manual plotting, the process of constantly exporting CSVs, cleaning data, and rebuilding reports can be incredibly time-consuming. We built Graphed to solve this by automating your entire analytics workflow. Instead of manually arranging columns and navigating menus, you can just ask in plain English, "Show me a scatter plot of Shopify sales vs. Facebook Ads spend for last quarter," and instantly get a live, interactive visualization connected directly to your sources.