How to Make a Chart in Google Sheets (Step by Step)

To make a chart in Google Sheets, select your data, click Insert → Chart, and Sheets creates a chart automatically — then customize the type, titles, and colors in the Chart editor. It takes under a minute, and the chart stays linked to your cells, so it updates whenever the numbers change.

Step by step

1. Select the data you want to chart (including the header row and labels).
2. Click Insert → Chart.
3. Sheets inserts a chart and opens the Chart editor on the right.
4. Under Setup → Chart type, pick the type you want (bar, line, pie, etc.).
5. Customize under the Customize tab — title, colors, axis labels.
6. Drag the chart to position it, or resize it by its corners.

Choosing the right chart type

The type should match the question you are answering. The full menu is under Setup → Chart type.

Bar is horizontal; Column is vertical. They answer the same question — a horizontal Bar simply reads better when you have long category names.

Switch rows and columns

If your chart has categories and series the wrong way round, open Chart editor → Setup and tick Switch rows / columns. That one toggle fixes most “my chart looks upside down” problems — for example, when months should run along the bottom but appear in the legend instead.

Add a chart and axis titles

1. Click the chart and open the Chart editor.
2. Go to the Customize tab.
3. Expand Chart & axis titles.
4. Choose Chart title, then type it.
5. Use the dropdown to switch to Horizontal axis title or Vertical axis title and label each one.

A clear title plus labelled axes is the difference between a chart a colleague understands at a glance and one they have to decode.

Change colours and add data labels

To recolour a series, open Customize → Series, pick the series from the dropdown, and choose a fill colour. A good default is one accent colour for the series you want people to notice and muted grey for everything else. (For pie charts, the slice labels live under Customize → Pie chart → Slice label.)

To add data labels — the numbers printed on or beside each bar or point — open Customize → Series and tick Data labels. For a pie chart, the same area lets you show each slice’s percentage instead of its raw value.

Move a chart to its own sheet

A chart does not have to sit on top of your numbers. To give it a full page:

1. Click the chart once to select it.
2. Click the ⋮ (three dots) in its top-right corner.
3. Choose Move to own sheet.

Sheets creates a new sheet containing only the chart - ideal for a dashboard or a one-chart-per-page report. Note this moves the chart (it disappears from its original position); to duplicate it instead, use Copy chart.

Build a chart from a pivot table

Pivot tables summarise data — totals, counts, and averages by category — and charting that summary is often cleaner than charting raw rows.

1. Select your source data.
2. Go to Insert → Pivot table and choose where to place it.
3. In the Pivot table editor, add a field to Rows and a numeric field to Values.
4. Select the pivot table’s output, then click Insert → Chart.

Because the chart reads the pivot output, it updates automatically when the source data or the pivot layout changes. This is the standard way to chart grouped totals without writing a formula.

Chart the totals, not the raw rows

A common trap: you have 500 rows of sales and want a chart of monthly totals. Charting the raw data gives you a mess of 500 points.

Build the summary first, then chart it:

• Pivot table — Insert → Pivot table, put Month in Rows and Sum of Sales in Values, then chart the pivot output.
• SUMIF — =SUMIF(months, "Jan", sales) gives you twelve numbers to chart.
• QUERY — =QUERY(A:C, "select A, sum(C) group by A") summarises a whole column in one formula.

Make your chart update automatically

Sheets charts are live: they are bound to a cell range, not a snapshot. Edit any source cell and the chart redraws. Two things to watch:

• Keep the range contiguous. If you add new rows inside the existing range, the chart picks them up. If the range is wrong, fix it under Setup → Data range.
• Let formulas do the work. If you compute values with SUMIF or similar, the chart follows the result. For the basics, see Google Sheets formulas for beginners.

If you are working in Excel instead, the workflow is slightly different — see how to make a graph in Excel.

Quick reference: common customisations

Troubleshooting

Working in Excel instead of Sheets? See how to make a graph in Excel. If your numbers need building first, start with Google Sheets formulas for beginners.

FAQ

Can I change a chart after creating it?

Yes — click the chart → ⋮ → Edit chart to change the type, colors, or data range anytime. The Chart editor stays live while you make changes.

How do I add a title to a chart?

In the Chart editor’s Customize tab, expand Chart & axis titles, choose Chart title, and type your title. The same panel labels the horizontal and vertical axes.

Why is my chart blank or wrong?

Usually the data range is wrong — make sure the header row is included and you selected a clean rectangle of data with no empty gaps in the middle. Also check the cells hold numbers, not text.

Where is the Chart editor in Google Sheets?

The Chart editor opens on the right when you insert or double-click a chart. If it is closed, click the chart → ⋮ (three dots) → Edit chart to reopen it.

How do I make a pie chart in Google Sheets?

Select your data → Insert → Chart → in the Chart editor’s Setup tab, change Chart type to Pie. Pie charts work best with a single series of values that add up to a whole.