Customize a Chart

How to Customize a Chart in Google Sheets

Customize a Chart

Once you've inserted a chart into a sheet, you can make various changes to it. You can change the chart type, switch rows and columns, change a chart's title, and change a chart's legend.

Modify a Chart

Once you've inserted a chart into a sheet, you can make changes to it.

  1. Click the chart to select it.
  2. Click the More icon.
  3. Select Edit chart.
    Customize a Chart

The Chart editor pane appears. This is where you can make changes to your chart.

Change Chart Type

Different types of charts are better for presenting different types of information. For example, a column chart is great for comparing values of different items, but not for illustrating trends or relationships. If you find that a chart you've created isn't the best fit for your data, you can switch to a different chart type.

  1. Click the Chart type list arrow from the Chart editor pane.
  2. Select the type of chart you want.
    Customize a Chart

The chart type is changed.

Switch Rows and Columns

You can switch the rows and columns of data in a chart so they appear in opposite positions.

  1. Click the Switch rows / columns box in the Chart editor pane.
    Customize a Chart

The data in the spreadsheet's rows and columns is flipped.

Change a Chart Title

The chart title often appears above the chart and is used to describe the data that's being presented. You can add a completely new chart title or simply change the text of an existing one.

  1. Click the Customize tab in the Chart editor pane.
  2. Click the Chart & axis titles section to expand it.
  3. Click in the Title text field.
  4. Enter a chart title.
    Customize a Chart

Change a Chart Legend

You can also change your chart's legend.

  1. Click the Customize tab in the Chart editor pane.
  2. Click the Legend section to expand it.
  3. Specify the legend options.
    Customize a Chart

The legend is updated and we've finished making changes to the chart.

FREE Quick Reference

Click to Download