Edit a chart
You can customize your chart to an audience by changing options, like chart type, data range, or color.
Customize your chart
- On your computer, open a spreadsheet at sheets.google.com.
- Double-click the chart you want to edit.
- 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.
- On your computer, open a spreadsheet at sheets.google.com.
- Double-click the chart you want to edit.
- In the side panel, click Data
Data range.
- Check the box next to "Switch rows / columns" to switch the order of the data.
See hidden or filtered data in a chart
- On your computer, open a spreadsheet at sheets.google.com.
- Double-click the chart you want to edit.
- In the side panel, click Data
Data range.
- 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?