How to Make a Scatter Graph in Google Sheets: Step by Step

To make a scatter graph in Google Sheets, put your X values in one column and the matching Y values in the next, select both columns, then choose Insert > Chart and set Chart type to Scatter chart. A scatter graph plots each pair as a point, making it easier to see patterns, clusters, and possible relationships between two numeric variables. The steps below use Google Sheets in a desktop web browser.

What You’ll Need

A Google account and a spreadsheet open in Google Sheets.
Two columns of paired data: one numeric value for the horizontal (X) axis and one numeric value for the vertical (Y) axis. For example, hours studied and test scores.
Optional column headings, such as “Hours studied” and “Test score,” to make the chart easier to read.

Each row should describe one observation, and the X and Y values on that row must belong together. A scatter graph is most useful when both variables are numeric. If your first column contains names or categories rather than numbers, a bar or column chart may be more appropriate.

Step-by-Step

Arrange the data in columns. Enter the X-axis measurements in the first column and the corresponding Y-axis measurements in the second. Put the headings in the top row, with observations starting on the next row. For example, enter “Hours studied” in A1, “Test score” in B1, then put 1 and 62 in A2 and B2, 2 and 70 in A3 and B3, and so on. Keep each pair together on one row. Avoid blank rows within the data because they can make the chart range harder to interpret.
Select the chart data. Drag across both columns, including the headings and all the data rows. If the columns are next to each other, click the first cell and drag to the last cell in the second column. You can also select a range by clicking the name box above the sheet, typing a range such as A1:B10, and pressing Enter. Adjust the example range to match your actual last row. Selecting the headings helps Sheets use them as labels in the chart editor.
Insert a chart. With the data range selected, choose Insert > Chart from the menu. Google Sheets adds a chart to the sheet and opens the Chart editor, usually on the right. If it initially creates a different chart type, that is normal: you can change the type in the next step. The chart itself can be moved by dragging it and resized using its handles.
Choose Scatter chart. In the Chart editor, open the Setup tab and click the Chart type dropdown. Select Scatter chart. Look for it in the chart-type list; the available choices may be grouped or shown as small previews. Sheets will redraw the chart using the selected data. If you cannot see the editor, click the chart’s three-dot menu and choose Edit chart.
Check the X-axis and series assignments. In the Setup tab, check that the first numeric column is listed under X-axis and the second numeric column appears under Series. For the example, Hours studied should be the X-axis and Test score should be the series. If Sheets assigned the wrong range, use the range selector next to the relevant field and choose the correct cells. When headings are included, check the options to use the first row as headers and the first column appropriately, if shown. These choices help Sheets identify the heading and values correctly.
Add a clear chart title. Open the Customize tab in the Chart editor, then expand Chart & axis titles. Use the title-type dropdown to choose the chart title, then enter a concise title in the title text box. A useful title describes the comparison, such as “Study Hours and Test Scores.” You can also select the horizontal axis title and vertical axis title in the same section, then type labels that include the measurement or unit, such as “Hours studied” and “Score (points).”
Make the points and axes easy to read. In Customize, open Series to adjust the point color and point size where those controls are available. Choose a contrasting color and a size that is visible without making nearby points merge together. Open the horizontal or vertical axis section to adjust axis labels and, if needed, the minimum or maximum displayed value. Use sensible limits that include the data; a narrow range can exaggerate small differences. You can also use Chart style to adjust the chart background and border.
Review the finished graph. Close the Chart editor using its close control, then inspect the chart at its final size. Confirm that the horizontal axis represents X and the vertical axis represents Y, that the title and units are accurate, and that all intended points appear. Hover over a point to inspect its values if needed. If the chart needs changes, double-click it to reopen the Chart editor. Changes to the source data generally update the chart when the chart range includes those cells.

To add another numeric comparison, place its values in another column aligned row by row with the same X values, then add that column as a series in the Setup tab. Give each series a distinct heading and use clear colors so readers can tell them apart. Google Sheets scatter charts are not the same as line charts: a scatter chart places points according to numeric X values, while a line chart is commonly used to show values across categories or an ordered sequence.

Common Mistakes

Putting X and Y values in mismatched rows. Each row is one point. If you sort one column without sorting the paired column with it, the chart will plot incorrect relationships. Sort the full data range together.
Including a text label in the numeric values. A heading is fine, but words, stray spaces, or numbers stored as text in the data cells can prevent a proper numeric axis. Keep descriptive text in the header row and verify that measurements are real numbers.
Choosing a line chart instead. Line charts can connect observations in sequence and may treat the horizontal values as categories. Select Scatter chart when the actual numeric spacing between X values matters.
Leaving out units or using an unclear title. Readers may not know whether a value means minutes, dollars, or degrees. Include meaningful axis labels and units, and avoid titles such as “Chart 1.”
Using a misleading axis range. Manually setting a very narrow minimum and maximum can make a small difference look dramatic. Keep a scale that gives a fair view of the data and explain any deliberate zooming in the surrounding text.

Tips

Use one consistent unit for each variable. For example, do not mix centimetres and metres in one X column unless you convert them first.
Leave the original data intact and place the chart beside or below it. This makes it easier to check individual points and edit the source range later.
If points overlap, try increasing chart size or adjusting the point size in Customize > Series. Overlapping points can hide how many observations occupy the same position.
A trendline can help summarize a pattern, but it does not prove that one variable causes the other. If you add one, open Customize > Series and look for the Trendline option. The available settings depend on the chart and data.
For a chart intended for a report, give it enough space to show axis labels clearly. Check how it looks at the size at which it will be copied, printed, or shared.

The same idea works in Microsoft Excel, but the interface is different: select the data, then use Insert and choose an X Y (Scatter) chart. Excel’s chart controls and menus do not use Google Sheets’ Chart editor tabs, so follow Excel-specific instructions if you are working in that program.

Troubleshooting

The chart is blank or some points are missing: Check the selected data range in Chart editor > Setup. Make sure the range covers the full set of X and Y values, and remove unintended blank rows or cells that contain text. Verify that corresponding X and Y entries are on the same rows.
The axes or series are reversed: In the Setup tab, check the X-axis field and the Series field. Set the column containing the independent or horizontal measurement as X-axis, and the column to plot vertically as the series. If you selected columns in a different order, correct the fields directly rather than rearranging the data blindly.
Numbers appear as text or the points do not scale properly: Look for leading apostrophes, extra spaces, or inconsistent decimal separators. Click a suspicious cell and check whether its value is recognized as a number. Re-enter or clean the affected values, then confirm the chart updates. Applying a number format alone may change how a number looks, but will not necessarily convert text into a numeric value.
The title or labels do not appear: Reopen the chart by double-clicking it, then use Customize > Chart & axis titles. Select the specific title type from the dropdown and enter the text in its title box. If text is clipped, enlarge the chart or shorten the label.
New rows are not included: Reopen Chart editor > Setup and inspect the data range. Extend it to cover the added rows, or use a range that includes the space where future entries will go. Confirm that the new values are numeric and follow the same column arrangement.

Frequently Asked Questions

Can I make a scatter graph with more than one Y variable?

Yes. Keep the X values in one column and put each Y variable in its own column, with one observation per row. In Chart editor > Setup, add the additional columns as series and use clear headers so the legend can identify them.

Can a scatter graph use dates on the X-axis?

It can, provided the cells contain actual date values that Google Sheets recognizes, rather than date-like text. Format and check the dates in the sheet, then confirm that the chart uses the date column for its X-axis.

How do I show a trendline in Google Sheets?

Select the chart, open Customize > Series, and enable Trendline if the option is available for the selected series. A trendline summarizes a pattern; it should not be treated as evidence of cause and effect.

Will the scatter graph change when I edit the data?

Yes, when you edit values inside the chart’s data range, the plotted points generally update. If you add rows beyond that range, update the range in Chart editor > Setup so the new observations are included.

Can I create a scatter chart in the Google Sheets mobile app?

Chart-editing options can differ between the mobile app and the desktop browser. For the clearest access to the Setup and Customize controls described here, use Google Sheets in a desktop web browser.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.