How to Make a Graph in Google Sheets in Minutes (2026)

A column of numbers tells nobody anything. A graph does. When I want to see whether something is moving up, whether one month stood out or which product is carrying the rest, I turn the table into a chart, and Google Sheets will do that in a few clicks.

Google calls them charts, so you'll see both words in the app. The steps below follow Google's help pages for computer and Android, with a few habits that make the result easier to read when you show it to a client or your team.

Getting your Google Sheets data ready before you make a graph

Charts are only as clear as the table behind them. Before you click anything:

• Put labels in the first column, such as months or product names.
• Give each column of values a short heading in the row above it.
• Keep the block free of empty rows and columns.
• Leave out totals rows unless you want them plotted.

Sheets can usually work out headings by itself, but a tidy block gives it the best chance of guessing right. If the chart is heading into a presentation rather than staying in the spreadsheet, my round-up of Google Slides alternatives covers other places to build the deck.

Creating a graph in Google Sheets on a computer

1. Open your spreadsheet in Google Sheets.
2. Select the cells you want to include, headings and all.
3. Click Insert, then Chart.
4. Look at the chart that appears and the editor panel on the right.

That's the route in Google's help. Sheets picks a chart type to suit your data, and you can change it afterwards, so don't worry if the first guess is wrong.

Changing the chart type and data range in the chart editor

Double-click the chart to open the chart editor on the right. Google says it has two tabs, Setup and Customize. Setup is where you change the chart type or the data range, which is the set of cells in your chart. To change the range, click the grid icon under Data range, select the cells, optionally click Add another range, and click OK.

Google's chart types article covers combo, area, bar, scatter, stock, organizational and table charts. A rough guide to choosing:

You want to show	A good starting point
How something changes over time	Line or area chart
Comparing a few categories	Column or bar chart
How two measures relate	Scatter chart
Parts of a whole	Pie chart

Which chart types are available depends on the data, and Google notes that features differ between types. Gridlines work with line, area, column, bar, scatter, waterfall, histogram, radar and candlestick charts, while legends work with most of those plus pie charts.

Customising the look of your Google Sheets graph

The Customize tab is where a plain chart becomes one you'd show a client. Google lists the controls: gridlines, chart style including colours, background and fonts, chart and axis titles, and the legend, which describes the data in the chart.

1. Open Customize in the chart editor.
2. Give the chart a title that says what it shows.
3. Label the axes so nobody has to guess the units.
4. Use two or three colours at most.
5. Keep the legend only if there's more than one series.

To change a single bar or point, right-click it and choose Format Data Point. Google adds that you can put borders on bars and columns, but not on points or lines.

Moving, resizing and tidying a graph in Google Sheets

Click the chart and drag it to a new spot. To resize, drag the blue markers. Google also says you can double-click a title, legend or label to drag it, or use the arrow keys, and right-click then choose Reset layout to put an item back where it started. To delete an item such as a legend, double-click it and press Delete or Backspace.

Google lists keyboard navigation for charts too: Enter moves into a level, Tab cycles through elements, Esc moves out one level and Shift + Tab reverses direction. It's a useful detail if you rely on the keyboard.

Making a graph in the Google Sheets app on Android

Google's Android help runs like this:

1. Open the spreadsheet in the Google Sheets app.
2. Select the cells you want in your chart.
3. Tap the plus icon, then choose Chart.
4. If you want a different style, tap Type.
5. Tap the checkmark to finish.

The page I read links to a separate iPhone and iPad version, and I couldn't read its steps. Menus vary by app version, so if the buttons look different on your device, look for the same Chart option after tapping the plus icon.

Sharing a graph from Google Sheets with a team or client

A graph that lives only in your spreadsheet helps you. A graph other people see helps your business. Once the chart looks right, share the spreadsheet with the right access level so viewers can see it but not change it. Google's help has a separate article on saving or publishing a chart, and I'd read that before putting any chart on a public page, because publishing makes the underlying data visible too.

If you'd like to present the numbers inside a document rather than a spreadsheet, my guide on filling in a Google Docs template shows how I keep documents tidy and consistent.

If your Google Sheets graph looks wrong

1. Check the data range in Setup. It may include a blank column or miss a row.
2. Check whether headings are being treated as data. Include them in the range and look at the header options in Setup.
3. Try a different chart type from the Setup tab.
4. Remove stray text from number columns, because words in a number column can confuse a chart.
5. Select fewer columns to start with, then add ranges one at a time.

Frequently asked questions

How do I make a graph in Google Sheets?

Select your cells, click Insert, then Chart. Double-click the chart to open the chart editor and change the type or data range in Setup.

Is a graph the same as a chart in Google Sheets?

In the app, Google uses the word chart. Making a graph means inserting a chart, then choosing the chart type, such as line, column or pie.

How do I change what data my chart uses?

Open the chart editor, go to Setup, click the grid icon under Data range, select the cells, optionally add another range and click OK.

Can I make a chart on my phone?

On Android, select the cells, tap the plus icon, choose Chart and tap the checkmark. Menus vary by app version, and iPhone steps differ slightly.

How do I change colours and titles on a chart?

Use the Customize tab in the chart editor to change chart style, colours, fonts, titles, axis titles and the legend.