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

To make a plot graph in Google Sheets, arrange your data in columns, select the data range, and choose Insert > Chart. In the Chart editor, pick a chart type; for plotting how one numeric variable relates to another, choose a scatter chart and set the correct X-axis and series. You can then add a title, label the axes, and adjust the display. This guide is for Google Sheets in a web browser.

What You’ll Need

A Google account and access to Google Sheets in a browser.
A spreadsheet with the values you want to plot. For a scatter chart, use one column for X values and another for Y values, with each paired observation on the same row.
Optional: a short chart title, clear axis labels, and the units for each measurement.

You do not need to install chart-making software or write code. If your data is on paper or in another file, enter or import it into a sheet first. This guide uses a simple example: hours studied in one column and quiz scores in another. The same steps work for many other data sets.

Step-by-Step

Put the values into a clean table. Open a spreadsheet and place each variable in its own column. For example, enter Hours studied in A1 and Quiz score in B1. Put each student’s hours and score on the same row below the headings. Keep one observation per row, and do not insert blank rows between records. If you already have data, check that its headings and values follow this layout before making a chart. For a scatter chart, both columns should contain numeric values; text headings are fine in the first row.
Select the data, including its headings. Click the first heading cell, then drag across and down to include both columns and all the rows you want plotted. For the example, that means selecting A1:B6 if there are five observations. Including the headings helps Sheets identify the series and makes the chart easier to understand. If the columns are far apart, you can select one range and use the range field in the Chart editor to specify the data range, but adjacent columns are simplest for a first chart.
Insert a chart. With the range selected, choose Insert > Chart from the menu bar. Sheets adds a chart to the sheet and opens the Chart editor, usually on the right. It may choose a chart type automatically based on your data. Do not assume the suggested type is the best match: use the Setup tab in the Chart editor to select the chart type that fits your question.
Choose the chart type. In the Chart editor, open Setup, then open the Chart type menu. Choose Scatter chart when you want to plot paired numeric values and examine their relationship, such as study hours against score. A scatter chart places the first numeric variable on the horizontal axis and the second on the vertical axis. For values changing over time, a line chart is often easier to read; for comparing categories, consider a column or bar chart. The right type depends on what the data represents, not just on how many columns it has.
Check the X-axis and series assignments. In Setup, confirm that the X-axis is the column you intend to use as the horizontal measure and that the Series contains the values for the vertical measure. For the example, Hours studied belongs on the X-axis and Quiz score should be the series. If Sheets assigned the wrong column, use the X-axis control to select the appropriate range, and remove or replace an incorrect series before adding the right one. If the first row contains headings, make sure Use row 1 as headers is selected. Use Switch rows/columns only when your data is arranged across rows rather than down columns.
Add a chart title and axis titles. In the Chart editor, select Customize > Chart & axis titles. Use the title-type menu to choose Chart title, then enter a clear name such as “Study Hours and Quiz Scores.” Choose the horizontal or vertical axis title in the same area and describe the measure and units, for example “Hours studied” and “Quiz score (points).” A title like “Chart 1” or “Results” does not tell readers what is being compared. If the chart is for a report, use a title that states the subject without claiming more than the data shows.
Make the plot readable and place it. Open other options in the Customize tab if you need to adjust the legend, font, background, or gridlines. Keep the design simple: labels should be legible, and colors should help distinguish series rather than decorate the chart. Click outside the chart editor to close it. Drag the chart to move it, or use its corner handles to resize it. Recheck the data points and labels after resizing, especially if the chart sits beside the data table.
Review the chart against the source data. Compare a few plotted points with their corresponding table rows. Check that the smallest and largest values appear in sensible places, that no intended records are missing, and that the axes describe the variables correctly. If something is wrong, click the chart to reopen the Chart editor and correct the setup or data range. The chart is linked to the sheet data, so edits to included values will generally update the plotted chart automatically.

For a scatter chart, each dot represents one row of paired values. If one row says 2 hours and 70 points, the matching dot should be at approximately x = 2 and y = 70. This makes a scatter chart useful for seeing patterns, clusters, or unusual observations. A visible relationship does not by itself prove that one measure caused the other; the graph displays the data, while interpretation depends on how it was collected.

This guide uses Google Sheets, not Excel. In Sheets, insert a chart through Insert > Chart and configure it in the Chart editor side panel. Excel has its own chart controls on the ribbon, so its menu names and editing steps differ even though the underlying chart choices are similar.

Common Mistakes

Choosing a line chart for unrelated pairs. A line chart connects points in sequence and is usually most appropriate when the horizontal axis represents an ordered progression such as dates. For two numeric variables where each row is a paired observation, use a scatter chart.
Plotting headings or notes as data. Extra text or totals inside the selected range can create an unwanted category or series. Keep notes outside the data table, and select only the headings and records that belong in the graph.
Mixing up the axes. A chart can look plausible even when the variables are reversed. Confirm which measure should be horizontal and which should be vertical, then verify those assignments in Setup.
Leaving numbers stored as text. Values with stray spaces, apostrophes, or inconsistent formatting may not behave like numbers. Make sure the cells contain actual numeric values and use consistent units, such as minutes throughout instead of a mix of minutes and hours.
Making the chart hard to interpret. Missing axis labels, a vague title, too many colors, or a crowded legend makes it difficult to read. Use descriptive labels and remove visual elements that do not help explain the data.

Tips

Keep paired observations together. Each X value must stay on the same row as its matching Y value. Sorting just one column can break the pairings and create a misleading plot. If you sort, sort the complete table range.
Use units in headings or axis titles. “Distance (km)” is more informative than “Distance,” especially if a reader might confuse kilometers with miles. Be consistent with units before charting.
Use a chart type to answer a question. Choose scatter for a relationship between two numeric measures, a line chart for movement over an ordered sequence, and bars or columns for category comparisons. Do not select a type simply because it is the first option Sheets offers.
Keep the original values visible while checking. Positioning the graph near the source table makes it easier to compare a dot or bar with its underlying record. For a presentation, you can move the chart to a separate area or sheet after checking it.
Make changes in small steps. If you are unsure whether a setting improves the graph, change one option at a time and inspect the result. This makes it easier to undo a confusing display change and keep the chart readable.

Troubleshooting

The graph has no points or omits some rows: Click the chart and inspect the data range in Setup. Extend it to include all intended rows, and check for blank cells or values stored as text. For a scatter chart, confirm that both the X values and the series values are numeric.
The dots appear on the wrong axes: In Setup, verify the X-axis range and the Series range. If the data table has columns in an unexpected order, explicitly select the correct ranges rather than relying on automatic detection.
Sheets made a chart with the wrong type: Click the chart, open Setup, and choose the desired option from Chart type. Changing the type does not require recreating the source table.
The chart includes a heading as a data point: Check whether the header option is enabled. Select Use row 1 as headers when the first row contains labels; also confirm that your selected range begins with the intended header row.
Numbers appear in an unexpected order or spread: Check the cell contents and number formats. A date, decimal, or value with a different unit may be valid but much larger or smaller than the rest. Correct the source data first, then check how the chart updates.
The title or axis label will not change: Reopen the Chart editor, go to Customize > Chart & axis titles, and select the specific title type from its menu before editing the text. The chart title, horizontal axis title, and vertical axis title are separate fields.
The Chart editor is not visible: Click the chart once to select it, then use its three-dot menu and choose Edit chart if that option appears. If the chart is not selected, click it again; clicking a cell elsewhere closes the editor.

Frequently Asked Questions

Is a plot graph the same as a chart in Google Sheets?
People use “plot graph” to mean a visual display of data. In Sheets, the feature is called a chart. For plotting two numeric variables against each other, the chart type you usually want is Scatter chart.

How do I plot two columns against each other?
Put the values to compare in separate columns, with each matching pair on the same row. Select both columns, including their headings, choose Insert > Chart, then select Scatter chart in Setup. Check that the intended horizontal variable is the X-axis and the other column is the series.

Can I make a plot graph with dates?
Yes. Put dates in one column and measurements in another, then choose a line chart when you want to show how a measure changes over time. Make sure the date cells are recognized as dates and that the rows are in chronological order. A scatter chart can also display numeric date values, but a line chart is usually easier for a time series.

How do I change the graph after creating it?
Click the chart to open the Chart editor. Use Setup to change the chart type, data range, X-axis, or series; use Customize to change titles and appearance. Changes to the underlying cells are reflected in the chart when those cells are part of its data range.

Can I make a graph without headings?
Yes, but headings make it easier to identify the series and axes. If your selected range has no header row, make sure Sheets is not treating the first data row as labels. Add clear headings when possible, then check the header setting in Setup.

Why does my scatter chart show one dot instead of several?
Check that the selected range includes all observations and that each row has both an X value and a corresponding Y value. Also confirm that the values are numeric rather than text and that the entire range is assigned to the X-axis and series, not just a single cell.

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.