Want to get more out of Google Docs for work or school? Sign up for a free Google Workspace trial.
Add a second Y-axis
You can add a second Y-axis to a line, area, or column chart.
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart you want to change.
- At the right, click Customize.
- Click Series.
- Optional: Next to "Apply to," choose the data series you want to appear on the right axis.
- Under "Axis," choose Right axis.
- To customize the axis, click Right vertical axis. Then, make your changes.
Tip: You can’t add a second X-axis.
Switch rows & columns in a chart
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart you want to change.
- At the right, click Setup.
- Click Switch rows / columns.
Customize the axes
Edit the vertical axis
You can format the labels, set min or max values, and change the scale.
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart you want to change.
- At the right, click Customize.
- Click Vertical axis.
- Make the changes you want.
Tip: To hide the vertical axis line, uncheck the box next to "Show axis line".
Choose which data shows on the horizontal axis
- On your computer, open a spreadsheet in Google Sheets.
- Select the cells you want to include in your chart.
- Click Insert
Chart.
- At the right, click Setup.
- In the box next to "x-axis," click More
Edit.
- Select the cells you want to show on the horizontal axis.
- Click OK.
Edit the horizontal axis
You can format the labels or reverse axis order.
Tip: If the chart contains time series or numeric data, you can also change the min and max values.
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart you want to change.
- At the right, click Customize.
- Click Horizontal axis.
- Make the changes you want.
Add & edit axes titles
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart you want to change.
- At the right, click Customize.
- Click Chart & axis title.
- Next to "Type," choose which title you want to change.
- Under "Title text," enter a title.
- Make changes to the title and font.
Add & format tick marks
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart you want to change.
- At the right, click Customize.
- Under "Gridlines and ticks," check the box next to "Major ticks."
- Optional: You can check the box next to "Minor ticks" to have smaller ticks between the major ticks.
Tip: To customize your axis, you can change the spacing between ticks, line thickness, and color.