Can You Make a Graph in Google Sheets?

Yes—you can make a graph in Google Sheets by selecting your data and choosing Insert > Chart. Sheets creates a chart you can adjust in the Chart editor, and it can update as you change the source data.

What a graph means in Google Sheets

Google Sheets generally calls a visual representation of spreadsheet data a chart. People often use “graph” and “chart” to mean the same thing, and you can create one without installing an add-on or writing code. The chart is placed on the sheet alongside your data, so you can see both the underlying numbers and the visual summary.

A chart is useful when you want to make a pattern easier to see: whether sales rise over time, which category has the largest total, or how two measures relate. The best chart depends on what question the data should answer. A decorative chart is not necessarily a useful one; clear labels and an appropriate scale matter more than elaborate styling.

How to create a chart step by step

In Google Sheets in a web browser, arrange your data in rows or columns, select the range you want to chart, and follow these steps:

Choose Insert > Chart. Sheets inserts a chart and opens the Chart editor, usually in a panel on the right.
In the editor’s Setup tab, check that the data range is correct and review the suggested chart type. If needed, open the chart-type selector and choose another type.
Check that the intended category labels and data series are assigned correctly. For example, a table of months and revenue should use the months as the horizontal-axis labels and revenue as the series.
Open Customize to adjust titles, colors, the legend, axes, and other appearance options.
Click outside the chart editor when you are done. The chart remains on the sheet; drag it to reposition it or drag its handles to resize it.

You can also start with a blank area and choose Insert > Chart, then enter or adjust the data range in Setup. Selecting the cells first is usually easier because Sheets can make a reasonable guess about how to interpret them. If that guess is wrong, you can correct it in the editor rather than rebuilding the chart.

Choose a chart that fits the question

Before choosing a chart, ask what comparison or pattern you want readers to notice. Common options in Google Sheets include column, bar, line, pie, scatter, area, and combo charts. Each is suited to a different kind of data:

Column or bar chart: Compare values across categories, such as revenue by product. Bars are especially helpful when category names are long; columns often work well for a shorter set of labels.
Line chart: Show how a measure changes across an ordered sequence, often dates or months. It can make a trend easier to follow than a series of separate bars.
Pie chart: Show parts of a single whole, such as the share of a total contributed by a few categories. It is most readable with a small number of clearly distinct slices.
Scatter chart: Plot paired numeric values, such as advertising spend and sales, to show whether they appear related. It does not by itself prove that one measure causes the other.
Area chart: Emphasize the size of values over time. A stacked area chart can show how components contribute to a total, though many overlapping series can make it difficult to read.
Combo chart: Combine chart types, such as columns for monthly orders and a line for a target. It can help compare different measures, but use a second axis only when the differing scales make it necessary and label that axis clearly.

For example, if a table has one row per month and columns for online and in-store orders, a line chart can show how both channels change over time. If the goal is to compare the two channels in one particular month, a column chart may communicate that comparison more directly.

Prepare the data before charting

Charts depend on the structure of the source range. A simple table with one header row, one row per category or time period, and one column per measure is often easiest for Sheets to interpret. For example, put Month, Online orders, and Store orders in the first row, then enter one month and its two values on each following row.

Use descriptive headers rather than leaving the first row blank. Keep each column’s values consistent: a column intended to contain numbers should not mix numbers with notes such as “about 20.” Dates should be actual date values when you want them treated as dates, not merely text that looks like a date. Remove unrelated totals or notes from the selected range if they could be mistaken for another data point.

If your categories are in columns instead of rows, the chart may initially appear reversed. In the Chart editor’s Setup tab, use the option to switch rows and columns when that gives the intended series. Also check the options for treating the first row or column as headers or labels where available. The exact controls shown can depend on the chart type and the selected range.

Format titles, axes, labels, and colors

In the Chart editor, open Customize to make the chart understandable without requiring someone to inspect the source table. Under Chart & axis titles, choose a title or axis-title type and enter clear wording. A title such as “Monthly orders by sales channel” tells readers more than “Orders.” Axis titles can clarify units, such as dollars, hours, or number of customers.

Other useful adjustments include changing the legend position, selecting a readable font size, and showing data labels when exact values matter. Series controls can offer options such as colors and labels, depending on the selected chart type. Avoid putting a label on every point if the chart becomes crowded. Likewise, use colors with enough contrast and do not rely on color alone to distinguish information if the chart may be read in grayscale or by someone with color-vision differences.

For numerical axes, check whether the scale makes the comparison fair and easy to understand. A truncated vertical axis can make small differences look dramatic. If you change axis bounds or other scale settings, make the choice clear rather than using a misleading visual emphasis.

What happens when the data changes?

A chart refers to a range of cells in the spreadsheet. When values in that source range change, the chart generally reflects those changes, which makes it useful for a recurring report. However, if you add new rows outside the chart’s current data range, they may not automatically become part of the chart. Check the range in Setup and extend it when necessary.

You can usually edit an existing chart by double-clicking it to open the Chart editor, then changing its setup or customization options. To make a separate chart, select a different data range and choose Insert > Chart again. If you delete or move source cells, verify that the chart still uses the intended data; a chart can remain present while no longer answering the question you meant it to answer.

Common chart problems and how to fix them

If the chart looks empty, check that the selected range contains values Sheets can chart and that the series are included in Setup. If it has unexpected categories or an extra series, the range may include a total row, blank column, or explanatory note. Adjust the range and review the assignments for the horizontal axis and series.

Dates appear as separate text labels: Check that the cells contain date values and that the correct column is being used for the horizontal axis.
Categories and series are swapped: Try switching rows and columns in Setup, then verify the result against the source table.
Values are missing or wrong: Look for text stored in a numeric column, blank cells, or a range that stops before the last row.
The chart is hard to read: Reduce the number of series, choose a more suitable chart type, or simplify labels and colors.
A new entry does not appear: Check whether the chart’s data range includes the new row and expand it if needed.

It is also worth checking the source data before assuming the chart is at fault. A chart can accurately display an incorrectly entered value, duplicated category, or inconsistent unit. In a report, make sure all values are measured in the same units before comparing them.

Share, export, and use charts in other documents

A chart is part of its Google Sheets file, so sharing the spreadsheet with appropriate access lets collaborators view the chart with the data. Google Sheets supports collaborative editing, but the people you share with still need permission to access the file. Use the spreadsheet’s sharing controls to choose who can view or edit it, especially if the data is sensitive.

If you need a standalone image, use the chart’s three-dot menu and look for the download options available there. Google Sheets can offer formats such as PNG, PDF, or SVG for a chart. The available choices and presentation details may vary, so check the downloaded file before using it in a report. You can also copy a chart and paste it into another document or presentation; when prompted, the paste options may let you link it to the spreadsheet or paste it without a link. A linked chart can reflect later spreadsheet changes, while a static copy will not update from its source.

Google Sheets charts compared with Excel

Google Sheets and Microsoft Excel both create charts from selected spreadsheet data and provide controls for chart type, titles, axes, and appearance. Their interfaces and some detailed features differ, so instructions for one program should not be assumed to match the other. In Sheets, the browser-based route is Insert > Chart followed by the Chart editor; Excel for Microsoft 365 uses its own ribbon commands and chart tools.

Sheets is convenient when people need to work together in a shared online spreadsheet. Excel may be preferable in workflows that depend on Excel-specific features or established desktop files. You can also import or export spreadsheet files, but check the chart after conversion: formatting or chart behavior may not transfer exactly between programs.

Frequently Asked Questions

Can I make a graph in Google Sheets for free?
Google Sheets is available at no charge for personal use with a Google account. Some organizational Google Workspace plans have paid subscriptions and additional administration features, but making a basic chart does not require a paid chart add-on.

How do I make a graph from two columns?
Select both columns, including their headers, then choose Insert > Chart. Check in Setup that one column supplies the categories or horizontal-axis values and the other supplies the data series.

Can Google Sheets make a graph that updates automatically?
It updates when values in the chart’s source range change. If you add rows beyond that range, edit the range in the Chart editor so the new data is included.

Can I make a graph in Google Sheets on my phone?
The Google Sheets mobile apps can work with spreadsheets, but menus and chart-editing options differ from the browser interface and may be more limited. For the full set of browser instructions in this guide, open the spreadsheet in Google Sheets on a computer.

What is the easiest chart for beginners?
A column chart is a straightforward starting point for comparing a small number of categories, while a line chart is a common choice for showing change over time. Choose based on the question, then check that the labels and scale make the result clear.

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.