Edit a chart

You can customize your chart to an audience by changing options, like chart type, data range, or color.

Customize your chart

  1. On your computer, open a spreadsheet at sheets.google.com.
  2. Double-click the chart you want to edit.
  3. In the side panel, select a tab:
    • Data: Choose your chart type and data range.
    • Customize: Change the axes, series, and how your chart looks.
Switch rows and columns in a chart

Your data will automatically be displayed horizontally and vertically on the chart. You can change how your row and column data shows on the horizontal and vertical axes.

  1. On your computer, open a spreadsheet at sheets.google.com.
  2. Double-click the chart you want to edit.
  3. In the side panel, click Data and then Data range.
  4. Check the box next to "Switch rows / columns" to switch the order of the data.
See hidden or filtered data in a chart
  1. On your computer, open a spreadsheet at sheets.google.com.
  2. Double-click the chart you want to edit.
  3. In the side panel, click Data and then Data range.
  4. Check the box next to "Include hidden / filtered data."

Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.

Was this article helpful?
How can we improve it?