Add & edit a chart or graph

Make a chart or graph

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select the cells you want to include in your chart.
  3. Click Insert and then Chart.
Change the chart type
  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart you want to change.
  3. At the right, click Data.
  4. Under "Chart type," click the Down arrow Down Arrow.
  5. Choose a chart from the list.

Learn more about chart and graph types.

Change the data range

The "data range" is the set of cells you want to include in your chart.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart you want to change.
  3. At the right, click Data.
  4. Under "Data range," click Grid Grid.
  5. Select the cells you want to include in your chart.
  6. Optional: To add more data to the chart, click Add another range. Then, select the cells you want to add.
  7. Click OK.

Change the look of a chart

Change the background, font & other options

The options you can change depends on your chart type. Learn more about each chart.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart you want to change.
  3. At the right, click Customize.
  4. Click Chart style.
  5. Make the changes you want.
Edit gridlines

You can add gridlines to your chart to make the data easier to read.

Before you edit: Gridlines can be added to line, area, column, bar, scatter, waterfall, histogram, radar, or candlestick charts.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart you want to change.
  3. At the right, click Customize.
  4. Click Gridlines.
  5. Optional: If your chart has horizontal and vertical gridlines, next to "Apply to," choose the gridlines you want to change.
  6. Make changes to the gridlines.

Tips:

  • To hide gridlines but keep axis labels, use the same color for the gridlines and chart background.
  • To customize the number of gridlines, in the box under "Major gridline count" or "Minor gridline count," enter a number.
Edit titles

You can change titles, subtitles, or title fonts.

Before you edit: Titles and subtitles can be added to line, area, column, bar, scatter, pie, waterfall, histogram, radar, candlestick, or treemap charts.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart you want to change.
  3. At the right, click Customize.
  4. Click Chart & axis title.
  5. Next to "Type," choose which title you want to change.
  6. Under "Title text," enter a title.
  7. Make changes to the title and font.
Edit the legend

The legend describes the data in the chart. You can change the legend’s font and where it shows on the chart.

Before you edit: You can add a legend to line, area, column, bar, scatter, pie, waterfall, histogram, or radar charts.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart you want to change.
  3. At the right, click Customize.
  4. Click Legend.
  5. Make changes to the legend.

Add or edit legend headers

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart you want to change.
    • Tip: Make sure the text you want to appear in the legend is the first row or column of your data set.
  3. At the right, click Data.
  4. Choose an option:
    • If headers are in rows: Click Use row N as headers.
    • If headers are in columns: Click Switch rows / columns and Use column N as headers.

To edit text in the legend, change your header text.

Move or resize a chart

Move a chart
  1. On your computer, open a spreadsheet in Google Sheets.
  2. Click the chart you want to move.
  3. Drag the chart where you want it.
Resize a chart
  1. On your computer, open a spreadsheet in Google Sheets.
  2. Click the chart you want to change.
  3. Drag the blue markers to resize the chart.

Related articles

Was this article helpful?
How can we improve it?