Add a secondary axis in Google Sheets
Create a combo chart from A1:C5. In Customize > Series, place the Margin % series on the right axis. Do not change any values.
Verified by JosephineAbout 60 secondsCreate a combo chart from A1:C5. In Customize > Series, place the Margin % series on the right axis. Do not change any values.
Step-by-step
Select the targetCreate a combo chart from A1:C5.
Apply the changeIn Customize > Series, place the Margin % series on the right axis.
Shortcut or faster method
Use the menu path shown in the video and keep the target range selected until the change is applied.
Expected result
A combo chart uses A1:C5 and displays Margin % on the right axis.
Common mistake
Changing the source values while applying the formatting or structure change.
Troubleshooting
Re-select A1:C5 and repeat the final action. A combo chart uses A1:C5 and displays Margin % on the right axis.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Month | Revenue | Margin % |
| Jan | 1200 | 0.25 |
| Feb | 1500 | 0.28 |
| Mar | 1700 | 0.3 |
| Apr | 1900 | 0.32 |
Video transcript
- Open the prepared Practice spreadsheet.
- Select the target. Create a combo chart from A1:C5.
- Apply the change. In Customize > Series, place the Margin % series on the right axis.
- A combo chart uses A1:C5 and displays Margin % on the right axis.