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

StepWhat to do
1Open the spreadsheet in Google Sheets on your computer.
2Select the cells you want to include.
3Click Insert, then Chart.
4Double-click the chart to open the chart editor in the side panel.
5Use 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

  1. Open your spreadsheet and select the cells to include.
  2. Click Insert, then Chart.
  3. 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

TabWhat it controls
SetupChart type, data range, and whether rows or columns are used as headers.
CustomizeChart 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 typeGoogle says use it for
LineTrends over time.
ColumnComparing categories or groups, with stacked and 100% stacked versions.
BarDifferences between data points for one or more categories.
PieParts as shares of a whole, with a doughnut version.
ScatterRelationships and patterns between two numeric variables.
HistogramHow a data set is spread across ranges.
TableTurning 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

ChartFirst columnOther columns
Line and columnLabels for the horizontal axis.Numbers, one column per series.
PieA label for each slice.Positive numbers in the second column.
ScatterX-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.

  1. If your headers are in rows, click Use row N as headers.
  2. 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.

SectionWhat you can change
Chart styleBackground, font and other overall options, which vary by chart type.
Chart & axis titleChoose the title under Type, then edit the text and font.
LegendPosition, font, style and color.
GridlinesMajor 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.

  1. Double-click the chart.
  2. Click Customize, then Series.
  3. 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

  1. Double-click the chart.
  2. Click Customize, then Vertical axis or Horizontal axis.
  3. 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

TaskHow
Move the chartClick it and drag.
Resize the chartClick it and drag the blue markers.
Delete a title, legend or labelDouble-click it, then press Delete or Backspace.
Reset one moved itemRight-click it and click Reset layout.
Reset every itemCustomize, Chart style, then Reset layout.
Format one bar or pointRight-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 typeMeaning
Constant valueA fixed amount above and below each point.
PercentageA percentage of a specific item.
Standard deviationBars 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

KeyWhat it does
EnterSelects chart parts or goes one level deeper.
TabSwitches between elements at the same level.
Shift + TabMoves in the reverse direction.
EscMoves 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

  1. In the spreadsheet, click More on the chart, then Copy chart.
  2. Paste it into your Google Docs or Slides file.
  3. Leave Link to spreadsheet selected to keep it updated, or choose Paste unlinked for a static copy.
  4. Click Paste.

With a linked chart, click Update at the top of the chart after the source data changes.

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.

Leave a Reply

Your email address will not be published. Required fields are marked *