How to create a chart in Google Sheets
Learn how to turn spreadsheet data into a chart in Google Sheets, plus how to pick chart types, edit styles, and fix common display issues.
Quick answer
Select the data range you want to visualize, then click Insert in the menu bar and choose Chart. Google Sheets automatically generates a chart and opens the Chart editor panel, where you can change the chart type, adjust colors, add titles, and customize legends before closing the editor to place it on your sheet.
Steps at a glance
- Open your spreadsheet and select the data range
- Click Insert in the menu bar
- Choose Chart from the dropdown menu
- Pick a chart type in the Chart editor
- Customize colors, titles, and axis labels
- Click outside the editor to save the chart
- Drag the chart to reposition it on the sheet
Summary
Charts in Google Sheets turn raw rows and columns into visual graphs like bar, line, pie, and column charts, making trends and comparisons easier to spot at a glance. The built-in Chart editor lets you switch chart types and adjust formatting without leaving your spreadsheet, and the feature is fully available on the free plan.
Step-by-step guide
Step 1
Select your data range
Open the sheet containing the data you want to graph. Click and drag to highlight the cells, including header rows or labels, since Google Sheets uses these to build axis labels and legends automatically.
Step 2
Open the Insert menu
Click Insert in the top menu bar, then select Chart from the dropdown list. Google Sheets analyzes your selected data and inserts a chart with a suggested type based on the data structure.
Step 3
Choose a chart type
In the Chart editor panel that opens on the right, click the Chart type dropdown under the Setup tab. Browse options like column, bar, line, pie, area, or combo charts, and select the one that best represents your data.
Step 4
Adjust the data range if needed
Still in the Setup tab, check the Data range field to confirm it includes all the rows and columns you want. Use the Add another range option if you need to include extra series in the same chart.
Step 5
Customize the chart appearance
Click the Customize tab in the Chart editor to edit the chart title, axis titles, font size, colors, and legend position. These settings help make your chart clearer for whoever views the spreadsheet.
Step 6
Insert and position the chart
Click outside the Chart editor panel to close it and finalize the chart on your sheet. Drag the chart by its edges to move it, or click and drag a corner handle to resize it.
Step 7
Edit the chart later
Click anywhere on the chart, then click the three-dot menu icon in its top-right corner to reopen the Chart editor, edit the underlying data, or delete the chart entirely.
Why this matters
You've got a spreadsheet full of numbers — sales by month, survey responses, campaign results — and your stakeholders need to see the trend, not scan the rows. A chart turns that table into something a meeting can read at a glance.
Frequently asked questions
Is creating charts free in Google Sheets?
Yes. Chart creation is fully available with a free Google account and does not require any paid subscription or add-on.
Can I update a chart automatically when my data changes?
Yes. Charts in Google Sheets are linked to the source data range, so editing the values in those cells updates the chart automatically without needing to recreate it.
How do I move a chart to its own sheet?
Click the chart, open the three-dot menu in its corner, and select Move to own sheet. This places the chart on a separate tab for easier viewing or presenting.
Can I copy a chart into another document?
Yes. Click the chart, use the three-dot menu to select Copy chart, then paste it into a document, presentation, or another spreadsheet where it can stay linked to the original data.
Create interactive demos like this one — free, no coding required.
Start for free →