How To Make A Chart Or Graph In Google Sheets (2026)
You can turn any block of numbers in Google Sheets into a chart in three clicks.
The chart editor then lets you change the type, the data range, the titles, the labels and the axes.
This guide follows Google’s own help pages for the desktop version of Sheets.
Quick answer: make a chart in Google Sheets
| Step | What to do |
|---|---|
| 1 | Open the spreadsheet in Google Sheets on your computer. |
| 2 | Select the cells you want to include. |
| 3 | Click Insert, then Chart. |
| 4 | Double-click the chart to open the chart editor in the side panel. |
| 5 | Use the Setup tab for the chart type and data range, and the Customize tab for how it looks. |
Lay out your data first
Sheets reads the first column as labels for the horizontal axis.
The top row is optional, and when you include it, those names become the legend labels.
The other columns hold the numbers, and each row becomes one bar, point or line.
If the data is messy, fix it first with removing duplicates in Google Sheets so the chart does not count the same row twice.
Insert a chart
- Open your spreadsheet and select the cells to include.
- Click Insert, then Chart.
- Sheets places the chart on the sheet and opens the chart editor.
If the editor is closed, double-click the chart to bring it back.
Use the chart editor tabs
| Tab | What it controls |
|---|---|
| Setup | Chart type, data range, and whether rows or columns are used as headers. |
| Customize | Chart style, titles, series, legend, axes and gridlines. |
The two tabs sit at the top of the side panel, and every change shows on the chart straight away.
Pick the right chart type
On the Setup tab, click the down arrow under Chart type and choose from the list.
Google describes 18 chart types, and these are the ones most people need.
| Chart type | Google says use it for |
|---|---|
| Line | Trends over time. |
| Column | Comparing categories or groups, with stacked and 100% stacked versions. |
| Bar | Differences between data points for one or more categories. |
| Pie | Parts as shares of a whole, with a doughnut version. |
| Scatter | Relationships and patterns between two numeric variables. |
| Histogram | How a data set is spread across ranges. |
| Table | Turning a spreadsheet table into a sortable chart. |
The full list also includes combo, area, waterfall, radar, geo, tree map, gauge and candlestick charts.
Match your layout to the chart
| Chart | First column | Other columns |
|---|---|---|
| Line and column | Labels for the horizontal axis. | Numbers, one column per series. |
| Pie | A label for each slice. | Positive numbers in the second column. |
| Scatter | X-axis values. | Y-axis values, each column a separate series. |
A stacked or 100% stacked column chart needs at least two data series.
Fix a chart that shows the wrong data
If the axes are swapped, open the Setup tab and click Switch rows / columns.
Make sure the legend text sits in the first row or first column of your data.
- If your headers are in rows, click Use row N as headers.
- If your headers are in columns, click Switch rows / columns and then Use column N as headers.
To change which cells are plotted, click the grid icon under Data range, select the cells, and click OK.
You can also click Add another range to include more data.
Change the title, legend and style
Open Customize and use these sections.
| Section | What you can change |
|---|---|
| Chart style | Background, font and other overall options, which vary by chart type. |
| Chart & axis title | Choose the title under Type, then edit the text and font. |
| Legend | Position, font, style and color. |
| Gridlines | Major and minor gridline counts, and which axis they apply to. |
You can also double-click a title on the chart itself to edit it in place.
Add data labels
Data labels work on bar, column, scatter, area, line, waterfall, histogram and pie charts.
- Double-click the chart.
- Click Customize, then Series.
- Check the Data labels box.
You can then choose whether labels sit inside or outside the bars, and change their font, color and number format.
For a stacked chart, pick a series next to Apply to and click Total data labels to show totals.
On a pie chart, go to Customize, then Pie chart, and choose an option under Slice label.
Edit the axes
- Double-click the chart.
- Click Customize, then Vertical axis or Horizontal axis.
- Format the labels, reverse the order, or set minimum and maximum values.
For a second vertical axis on a line, area or column chart, go to Customize, then Series, and choose Right axis under Axis.
Google notes that you cannot add a second horizontal axis.
Pie chart limits to know
A pie chart shows one data series, so it needs one label column and one column of positive numbers.
Google states that a label with a negative or zero value will not show up in the chart.
Move, resize and delete parts of a chart
| Task | How |
|---|---|
| Move the chart | Click it and drag. |
| Resize the chart | Click it and drag the blue markers. |
| Delete a title, legend or label | Double-click it, then press Delete or Backspace. |
| Reset one moved item | Right-click it and click Reset layout. |
| Reset every item | Customize, Chart style, then Reset layout. |
| Format one bar or point | Right-click it and click Format Data Point. |
Other series options on bar, column, line and scatter charts
The Series section is where Google places bar colors, axis placement, error bars, data labels and trendlines.
To add error bars, check the Error bars box and choose the type and value.
| Error bar type | Meaning |
|---|---|
| Constant value | A fixed amount above and below each point. |
| Percentage | A percentage of a specific item. |
| Standard deviation | Bars centered on the series mean, not on each value. |
Error bars can be added to bar or line charts.
Move around a chart with the keyboard
| Key | What it does |
|---|---|
| Enter | Selects chart parts or goes one level deeper. |
| Tab | Switches between elements at the same level. |
| Shift + Tab | Moves in the reverse direction. |
| Esc | Moves up one level. |
Hold Ctrl on Windows or Command on a Mac while clicking to move or resize several items together.
Copy a chart into Docs or Slides
- In the spreadsheet, click More on the chart, then Copy chart.
- Paste it into your Google Docs or Slides file.
- Leave Link to spreadsheet selected to keep it updated, or choose Paste unlinked for a static copy.
- Click Paste.
With a linked chart, click Update at the top of the chart after the source data changes.
Related Sheets guides and sources
If you work in both programs, see how to convert Excel to Google Sheets and back.
To keep headers visible while you scroll through chart data, read how to freeze rows and columns in Google Sheets.
Google’s pages used here are Add and edit a chart or graph, Types of charts and graphs in Google Sheets and Edit your chart’s axes.