Create and customize a chart in Google Sheets
Create a chart in Google Sheets with Insert > Chart, then customize titles, colors, legend, and labels in the Chart editor. Fixes for charts that plot wrong.

Quick answer
Select your data including the header row, then click Insert > Chart. Google Sheets inserts a suggested chart and opens the Chart editor. Use the Setup tab to change the chart type, data range, and which column is the X axis. Use the Customize tab to edit titles, series colors, the legend, gridlines, and data labels. Changes apply as you make them.
Steps at a glance
- Select the data range, including headers
- Click Insert > Chart
- Pick a chart type in the Setup tab
- Check the data range and X axis
- Open the Customize tab for titles, colors, and legend
- Close the Chart editor with the X
- Drag the chart to reposition it on the sheet
Interactive demo
Summary
Most chart problems come from the shape of the data, not the Chart editor. Put labels such as months or names in the first column, one series per column after that, and one header row on top. Then Insert > Chart usually picks the right type. Setup controls what the chart shows. Customize controls how it looks.
Step-by-step guide
Step 1
Select your data range
Highlight the cells you want to chart, including the header row. Keep labels such as months or product names in the first column and each series in its own column. Sheets uses that layout to build the axis and legend.
Step 2
Insert the chart
Click Insert in the top menu bar, then select Chart. Google Sheets inserts a chart with a suggested type and opens the Chart editor panel on the right.
Step 3
Choose a chart type
In the Setup tab, open the Chart type dropdown. Line charts suit trends over time, column or bar charts suit comparisons between categories, and pie charts suit parts of one total. See also make a bar graph and make a line graph.
Step 4
Check the data range, X axis, and series
Still in Setup, confirm the Data range covers every row you want. Check that the X-axis is your label column and each series is a number column. If the chart looks sideways, tick Switch rows / columns. If the header row is plotted as data, tick Use row 1 as headers.
Step 5
Customize titles and series colors
Click the Customize tab. Under Chart & axis titles, pick Chart title or an axis title from the dropdown and type the text. Under Series, choose a series and set its color, and tick Data labels to show exact values on bars or points.
Step 6
Set the legend and gridlines
Under Legend, choose a position (top, bottom, right, or none) and font size. Under Gridlines and ticks, reduce or remove gridlines for a cleaner chart. Read more in add a legend and add an X axis.
Step 7
Position the chart and edit it later
Close the editor with the X, then drag the chart to move it or drag a corner handle to resize it. To change it later, double-click the chart, or click it and choose Edit chart from the three-dot menu.
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.
Troubleshooting
Numbers don't plot, or the chart is empty
The values are probably stored as text, often from a CSV or copy-paste. Select the column and choose Format > Number > Number. If they stay left-aligned, re-enter them or remove stray spaces and currency symbols.
Months or names appear as a series instead of on the X axis
In Setup, tick Switch rows / columns, or set the X-axis field to the label column and remove it from the Series list.
New rows don't show up in the chart
The data range stops at the last row you selected. Edit the range in Setup to cover whole columns, such as A:C, or extend it well past the last row, such as A1:C1000, so new rows are included.
The header row appears as a data point
Tick Use row 1 as headers in the Setup tab. If the header isn't in row 1 of the range, adjust the Data range so it starts on the header row.
Frequently asked questions
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. Rows added below the range are not included until you extend the data range.
Can I chart columns that aren't next to each other?
Yes. Hold Ctrl (Cmd on Mac) while selecting each column before you click Insert > Chart, or add each range later with Add range in the Setup tab.
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 reuse the same custom style on another chart?
There's no style copy. Duplicate the formatted chart (three-dot menu > Copy chart, then paste) and change its data range in the Setup tab.
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.
Related guides
Continue with more step-by-step guides for getting work done.
How to add a legend to a chart in Google SheetsLearn how to add, edit, and reposition a legend on any Google Sheets chart using the Chart editor's Customize tab.
How to add an X axis in Google SheetsAdd and label the X axis on a Google Sheets chart from the Chart editor's Customize tab: set the axis title, then style its labels. Interactive demo included.
How to make a bar graph in Google SheetsLearn how to turn spreadsheet data into a clear bar graph in Google Sheets, from selecting your data to customizing colors and labels.
How to make a line graph in Google SheetsLearn how to build and customize a line graph in Google Sheets, from selecting data to styling axes, legends, and colors on the free plan.
How to create a filter in Google SheetsLearn how to create a filter in Google Sheets to sort, hide, and analyze data quickly using the built-in filter tool on any free account.
How to create a filter view in Google SheetsLearn how to create a filter view in Google Sheets to sort, filter, and analyze data privately without changing what collaborators see in the file.
Create interactive demos like this one — free, no coding required.
Start for free →