How to Make a Graph in Google Sheets on a Computer

To make a graph in Google Sheets on a computer, arrange your information in labeled rows or columns, select the data, then choose Insert > Chart. Use the Chart editor to pick a chart type and adjust its labels, colors, and other settings. Your graph appears in the sheet and updates when its source data changes.

What You’ll Need

A computer with a web browser and access to Google Sheets.
A spreadsheet containing the data you want to graph. Include a heading for each column or row, and make sure the values you want to compare are entered consistently.
Optional: a clear idea of what you want the graph to show, such as change over time, comparisons between categories, or the relationship between two sets of numbers.

You can start with a blank spreadsheet or an existing one. These directions are for Google Sheets in a browser; the menus and Chart editor may look a little different in the Sheets mobile app.

Step-by-Step

Organize the data. Put related information in a compact table with no completely blank rows or columns breaking it up. For example, enter Month in A1, Visitors in B1, and Sign-ups in C1. Put January, February, and March in A2:A4, then enter the matching visitor and sign-up counts in columns B and C. Each row should describe one month, and each column should contain one kind of information. Clear headings help Sheets identify the series and label the graph.
Open the spreadsheet and select the range. Click the first cell of the table, then drag to the last cell so the headings and values are all highlighted. In the example, select A1:C4. Including the headings helps Sheets use Visitors and Sign-ups as series names rather than treating those words as data. If the table is large, click the first cell, hold Shift, and click the last cell to select the rectangle between them.
Insert a chart. With the range selected, click Insert > Chart in the menu bar. Sheets places a chart in the spreadsheet and opens the Chart editor, usually in a panel on the right. It chooses a chart type automatically based on the selected range. The first chart is only a starting point; you can change the chart type and data after it appears.
Choose a chart type. In the Chart editor, open the Setup tab and click the Chart type dropdown. Choose a line chart when the order of values matters, such as showing monthly visitors over time. Choose a column or bar chart to compare categories, such as sign-ups by month. A pie chart is better suited to a small set of categories that make up one whole. For values that represent paired measurements, such as advertising spend and sales, a scatter chart can show whether the two variables move together.
Check the data range and labels. In Setup, inspect the data range and the fields for the X-axis and Series. Make sure the months or categories appear as the axis labels and the numbers appear as series. If your first row contains headings, enable Use row 1 as headers; if the first column contains category labels, enable Use column A as labels when those options are shown. The exact label option depends on your data range. Use Switch rows / columns if Sheets has treated each row as a separate series when you intended each column to be one.
Add a useful title and labels. Open the Customize tab in the Chart editor, then expand Chart & axis titles. Choose the title or axis-title field you want to edit and type a concise description. For example, Monthly Website Visitors tells readers what the graph measures and the period it covers. Add axis titles when the units might not be obvious, such as Visitors or Revenue in dollars. Avoid titles that merely repeat a column heading if they do not explain the chart.
Adjust the appearance if needed. In Customize, explore sections such as Chart style, Legend, Series, and Horizontal axis. You can change the background, legend position, or series colors, and—for chart types that support it—show data labels. Keep the design simple enough that the values remain easy to compare. If there are several series, choose colors that are visibly distinct and retain a readable legend.
Place and resize the graph. Click the chart to select it, then drag it to a clear area of the sheet. Drag a corner or edge handle to resize it; making the chart wider can help longer category labels fit. Click outside the chart when you are done. Google Sheets saves changes to the spreadsheet automatically, so you do not need a separate save command. If you edit the cells used by the chart later, the graph normally reflects those changes automatically.

Common Mistakes

Leaving out the headings. Selecting only the numbers can produce generic series names or confusing axis labels. Select the heading row or column along with the values whenever possible.
Including unrelated cells. A title, note, total, or empty block inside the selected range can be interpreted as chart data and distort the result. Select only the table needed for the graph. If totals are not part of the comparison, leave them out.
Choosing a chart type that hides the point. A pie chart with many categories is difficult to read, while a line chart can imply a continuous sequence when the categories are unrelated. Match the chart to the question: trends, category comparisons, or parts of a whole.
Using inconsistent values. If a column mixes numbers with words, or stores numeric-looking entries as text, Sheets may omit values or plot them incorrectly. Keep each series consistent and put units in the heading rather than typing them after every number.
Making the graph too busy. Too many series, decorative effects, or long labels can make the main comparison hard to see. Remove data that does not support the point and use a straightforward title and legend.

Tips

Decide what question the graph should answer before choosing a chart type. A graph is easier to interpret when it focuses on one comparison, such as how visitors change month by month.
Sort category data in a meaningful order. Dates should normally run from earliest to latest, and ranked comparisons may be easier to scan from largest to smallest.
Use consistent units within a series. If one column contains percentages and another contains counts, consider whether they belong on the same chart; different scales can make one series look nearly flat.
Keep the original table intact. It is usually easier to correct the source cells and let the chart update than to rebuild a graph after changing its underlying data.
When the chart will be viewed by other people, make the title and axis units understandable without requiring them to inspect the source table. A chart should provide enough context to stand on its own.

Troubleshooting

The chart is blank or missing some values: Return to Setup and check that the data range includes the cells you intended. Look for blank cells, text in a numeric column, or numbers stored as text. If necessary, correct the source values and confirm that the range still covers them.
The wrong labels or series appear: Check the X-axis and Series fields in Setup. Turn on the header or label options if they fit your table, or use Switch rows / columns to reverse how the data is grouped. Confirm that the range starts at the correct heading cell.
The graph shows one point or one category: The selected range may contain only one row or one column of values, or the chart type may not fit the data. Expand the range to include the full table. For a time series, include both the date or period column and the value column.
Dates or categories appear in the wrong order: Check the order in the source cells and make sure dates are recognized as dates rather than plain text. Sort the source table into the intended order, then review the chart. If the axis itself is reversed, look for the relevant axis settings under Customize.
Labels are cut off or hard to read: Make the chart wider, shorten the category names in the source data, or move the legend to a less crowded position using Customize > Legend. A simpler chart type can also improve readability when many labels are competing for space.
The Chart editor has disappeared: Click the chart to select it and open its editing controls. If the panel is closed, double-clicking the chart usually reopens the Chart editor. You can then make changes under Setup or Customize.

Frequently Asked Questions

Can I make a graph in Google Sheets without selecting the data first?

Yes. Click a cell within a well-organized data table and choose Insert > Chart. Sheets may detect the surrounding range automatically. Check the data range in Setup, because automatic detection can include extra cells or miss data in a separated area.

How do I change a graph after creating it?

Double-click the graph to open the Chart editor. Use Setup to change the chart type or data range, and use Customize to adjust titles, the legend, and appearance. Changes to the source data can also update the graph.

What is the best graph type for data over time?

A line chart is often a good choice for showing a trend across dates or ordered periods. A column chart can also work for a small number of periods when you want to compare individual totals. Choose the one that makes the pattern easiest to understand.

Can I make a graph using only some columns in a larger table?

Yes. Select just the relevant range before inserting the chart, or edit the data range and series in the Chart editor. A clean, compact source range helps prevent unrelated columns from appearing in the graph.

Does a Google Sheets graph update when I change the data?

Usually, yes. If the cells are part of the chart’s data range, edits to their values are reflected in the graph. If you add new rows outside the range, check the range in Setup and expand it if needed.

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.