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 ?
7 Replies
Sort By
- McXcelCopper ContributorJudging 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.
- McXcelCopper 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.
Hi Peter,
Format one of your series to plot on secondary axis, both vertical and horizontal secondary axis will be available, you may hide vertical and show only horizontal
- Peter HavordCopper Contributor
Can you please provide a click by click guide ?
SergeiBaklan wrote:Hi Peter,
Format one of your series to plot on secondary axis, both vertical and horizontal secondary axis will be available, you may hide vertical and show only horizontal
Please check, for example, here https://www.youtube.com/watch?v=84Al7vxBJCU