Edit and format your chart

You can edit and format a chart a number of different ways to display it how you want.

Make quick edits

To make small, fast edits to a chart, you can use Quick Edit mode with many different chart types.

  1. Open a spreadsheet and click on a chart.
  2. On the right, click the Quick edit mode icon .
  3. Click the part of the chart that you'd like to change:
    • Chart title: Change the font style, size, or color.
    • Horizontal or vertical axis labels: Change the font style, size, or color.
    • Legend: Change the font style, size, data series color, or position.
    • Data series: Change the color, line thickness, dot size, or axis it belongs to. For example, click on a line you want to edit in a line chart or click on a bar in a bar chart.
    • Chart background: Resize your chart, move it within the chart area, change the font or background color, or adjust the number of grid lines shown.

Note: A number of these editing features are also available by right-clicking on a section of your chart.

Make advanced edits

To fully customize your chart, you can use Advanced Edit mode.

  1. Open a spreadsheet and click on a chart.
  2. In the top right, click the dropdown arrow.
  3. Select Advanced edit.
  4. In the window that appears, select a tab:
    • Recommendations: Choose from a list of recommended chart types to display your data.
    • Chart types: See a list of all chart types.
    • Customization: Make changes to the axes, series, and appearance for your chart.

More customization options

Switch rows and columns in a chart

To switch the position of the rows and column data in your chart:

  1. Open a spreadsheet and click on the chart.
  2. In the top right, click the dropdown arrow.
  3. Select Advanced edit.
  4. In the window that appears, select the Chart types tab.
  5. Check the box next to "Switch rows/columns" to switch the order of the data.
Include hidden or filtered data in a chart

To include data in your chart that has been hidden or filtered in a spreadsheet:

  1. Open a spreadsheet and click on the chart.
  2. In the top right, click the dropdown arrow.
  3. Select Advanced edit.
  4. In the window that appears, select the Chart types tab.
  5. Check the box next to "Include hidden/filtered data."
  6. To remove this data from the chart, uncheck the box again.

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

Was this article helpful?