Creating Y2 axis on microsoft 365 online excel document

New Contributor

Hi, I am attempting to create an excel chart with a y2 axis, but clicking on the trendline and clicking format leads to this picture. I have watched countless "how-to" videos online to do this but none of them align with the options given on my screen when I click the same thing (if that makes sense). Shown is where I generally get stuck: of all the drop-down menus to the side, none of them contain an option to add a secondary/y2 axis. Any advice would be greatly appreciated, have a great day!

Screen Shot 2022-03-21 at 3.34.06 PM.png

2 Replies


Creating a secondary axis is not (yet) supported in the online version of Excel.

You will have to open the workbook in the desktop version of Excel for Windows or MacOS in order to create a secondary axis.

@Hans Vogelaar Great to know. Appreciate the info and quick response!