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, but you can add series sets.
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
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.
Chart.
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.
Group horizontal axis data
To show more info, you can label groups of columns on the horizontal axis.
- On your computer, open a spreadsheet in Google Sheets.
- Ensure that the data has more than one X-axis column. For example: Year, Quarter, and Month.
- Double-click the chart you want to change.
- At the right, click Setup.
- Next to “Grouping,” click Add.
- Pick the group you want.
- To add more groups, click Add again.
Add series sets (domain sets)
To show sets of data side by side, you can add X-axis columns to your spreadsheet and chart. For bar charts, you can also add Y-axis columns.
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart you want to change.
- At the right, click Setup.
- At the bottom, click Add axis & series set.
- Pick your X-axis and series.
To add more series sets, click Add axis & series set again.
Change axis titles & tick marks
- 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.
- 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.
