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 that you want to change.
- On the right, click Customise.
- Click Series.
- Optional: Next to 'Apply to', choose the data series that you want to appear on the right axis.
- Under 'Axis', choose Right axis.
- To customise 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 and columns in a chart
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart that you want to change.
- At the right, click Setup.
- Click Switch rows/columns.
Customise 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 that you want to change.
- On the right, click Customise.
- Click Vertical axis.
- Make the changes that you want.
Tip: To hide the vertical axis line, untick the box next to 'Show axis line'.
Choose which data will appear on the horizontal axis
- On your computer, open a spreadsheet in Google Sheets.
- Select the cells that 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 that 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 that you want to change.
- On the right, click Customise.
- Click Horizontal axis.
- Make the changes that you want.
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 that 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 that you want to change.
- On the right, click Customise.
- Click Chart and 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 that you want to change.
- On the right, click Customise.
- Under 'Gridlines and ticks', tick the box next to 'Major ticks'.
- Optional: You can tick the box next to 'Minor ticks' to have smaller ticks between the major ticks.
Tip: To customise your axis, you can change the spacing between ticks, line thickness and colour.
Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.
