To make a graph in Google Sheets, select your data, click Insert > Chart, and then choose a chart type and refine the details in the Chart editor panel that opens on the right.
Google Sheets can turn a range of numbers into a chart in a couple of clicks, then let you customize almost every element. The steps below reflect current Google Sheets on the web; the mobile app is similar but has fewer editing options. All you need to start is data laid out in rows and columns with clear headers.
Insert a chart
- Select the range you want to plot, including the header row and label column. For example, highlight A1:B7 where column A holds months and column B holds sales.
- Click Insert in the top menu, then Chart.
- Google Sheets inserts a chart and opens the Chart editor on the right. It picks a type automatically based on your data.
- If the suggested type is not what you want, open the Setup tab and choose a different one from the Chart type drop-down.
Choose the right chart type
The best chart depends on what your data shows. A few common choices:
| Chart type | Best for |
|---|---|
| Column or bar | Comparing values across categories |
| Line | Showing a trend over time |
| Pie | Showing parts of a whole (a single series) |
| Scatter | Showing the relationship between two numeric variables |
| Combo | Overlaying two series, such as bars plus a line |
As a rule, use a line chart for data measured over time, a column or bar chart to compare separate categories, and a pie chart only when the slices add up to a meaningful whole.
Customize the look
Open the Customize tab in the Chart editor to control the appearance:
- Chart style — background color, border, and font.
- Chart & axis titles — add or edit the main title and the horizontal and vertical axis titles.
- Series — set colors, add data labels, and choose the point or line style.
- Legend — move it to the top, bottom, or side, or hide it.
- Horizontal / Vertical axis — set the number format, and adjust the minimum and maximum values.
- Gridlines and ticks — control the spacing of the reference lines.
Every change previews live, so you can experiment freely. To reopen the editor later, double-click the chart or click its three-dot menu and choose Edit chart.
Fix a chart that plots the wrong way
If your categories and values look swapped, open the Setup tab and toggle Switch rows / columns. Also check Use row 1 as headers and Use column A as labels so your labels appear on the axis rather than being treated as data. Getting these two settings right fixes the large majority of “my chart looks wrong” problems.
Move, resize, and place the chart
You can drag the chart anywhere on the sheet and resize it using the blue handles at its corners. For a bigger view, click the three-dot menu and choose Move to own sheet, which places the chart full-screen on its own tab. To bring it back, use the same menu and choose Move to sheet.
Add a second data series
To plot more than one series — say, sales and target side by side — include all the relevant columns in your selection before inserting the chart, or open the Chart editor’s Setup tab and click Add series. Each series can be styled independently under the Customize tab, and a combo chart lets you show one series as columns and another as a line on the same axes. If the scales are very different, you can assign one series to a right-hand axis so both remain readable rather than one dwarfing the other.
Download or reuse the graph
To use the graph elsewhere, click the three-dot menu at the top right of the chart, choose Download, and pick PNG for slides and documents, PDF for print, or SVG for a scalable vector version. You can also copy the chart and paste it into Google Docs or Slides, where you can choose to keep it linked so it updates when the source data changes. If you would rather grab a quick image of the whole screen instead, and you use a Mac, our guide on taking a screenshot on a Mac explains the shortcuts.
Prepare your data first
A clean data range makes for a clean chart. Remove stray blank rows, keep one header per column, and make sure numbers are stored as numbers rather than text — a numeric column that Sheets reads as text will not plot correctly. If you are building an interactive report, tidy headers of the kind covered in merging cells for the title row help the shared version read cleanly around your new graph. And if you get stuck deciding which chart best fits your figures, an assistant built on a large language model can suggest a chart type, though you should sanity-check its advice against what your data actually shows.
Common charting mistakes to avoid
A few habits keep your graphs honest and readable. Do not start a bar chart’s value axis anywhere other than zero, because a cropped axis exaggerates differences. Limit a pie chart to a handful of slices — beyond about six, a bar chart is clearer. Label your axes so readers know the units, and avoid plotting too many series on one chart, which quickly becomes a tangle. Well-chosen, clearly labeled charts do the explaining for you, which is the whole point of turning numbers into a picture.
