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

  1. Select the data range, including headers
  2. Click Insert > Chart
  3. Pick a chart type in the Setup tab
  4. Check the data range and X axis
  5. Open the Customize tab for titles, colors, and legend
  6. Close the Chart editor with the X
  7. Drag the chart to reposition it on the sheet

Interactive demo

Loading 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

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

  7. 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.

Create interactive demos like this one — free, no coding required.

Start for free →