Forum Discussion
Peter Havord
Jun 06, 2018Copper Contributor
Add second x axis to Excel 2016
Hi, I use Excel 2016 and want to add a second x axis. How do I do this ?
McXcel
Jan 08, 2020Copper Contributor
Judging by other similar questions, if you are on Mac it is not possible to add a secondary axis. The help gives the correct instructions, but the option is not available on the menu.
- McXcelJan 08, 2020Copper Contributor
Peter Havord I found a workaround for the bug in the Excel menus. The help is just wrong (it should be right, but the menu apparently has a bug).
1. Select the series you want to add a secondary axis for
2. Right-click (two-finger tap) on the series
3. Select "Format Data Series..."
4. In helper window on the right, you can choose to plot the series on primary or secondary axis.