Excel - how to plot 2 vertical y-axes on a line graph

This video will demonstrate how to plot a line graph with two separate vertical y-axis. This is on version Microsoft Excel 365.

[@dimi1315]

Thanks a lot… This is so much better than other videos I’ve seen so far

[@willmilone4029]

Incredibly clear and helpful. Thank you so much!

[@andreahernandez20245]

This helped me out so much. Thank you!

[@mkm19067]

So helpful! Thank you

[@asfarsyed]

Very helpful with simple method great 👍

[@megascarythings2000]

Very helpful thank you

[@franksroom1891]

thanks so much for this!!!!

[@anime4life273]

The format data series never shows up for me

[@MohamadFawaz-ts4qx]

Thank you !

[@FaizKaz]

U r awesome

[@MoreLife_Aris]

Thanks this was very helpful!

[@ramsaha7940]

Thanks a lot

[@Brandi.Nicole]

This was great but when I right-clicked nothing came up - no options at all. No alternative axis choice. Ideas?

[@laurasmith_uos]

Hi Nicole, did you make sure you physically selected the line of data you wanted to plot as the secondary axis? You can either double click it and the 'format data series' options will appear or you can select the line then right click the option 'format data series'. I am working in Microsoft Excel 365, if you're working on a different version there may be subtle differences.

[@Brandi.Nicole]

@@laurasmith_uos student version through a college. Format tools limited. Only showing options for one axis point. No option to create a second. I’m on hour three trying to research it. I’m trying to graph wolf and elk populations in Yellowstone. All that data inputting!! 🙈Even Microsoft’s “help section” is wrong. Had someone in IT try to find it! Couldn’t figure it out. I’m at a loss. Thanks for responding though. It’s been a tough day.

[@Brandi.Nicole]

@@laurasmith_uos Hi 👋 Just in case anyone reads the comments - the newest student version of excel through the online platform does not have this function, you literally have to download the desktop version to your computer and then all the options appear! 🙌 Research paper complete! Thank you for your video!

[@laurasmith_uos]

@@Brandi.Nicole I'm glad you got your research paper sorted! Thank you for the advice regarding the student version too. Thank you.

[@Chuck_N0rris]

@@Brandi.Nicole Hah I am in the same situation a year later. Different problem though. I am trying to plot in two different graphs representing a lab test. Excel just wont cooperate with just plotting in the X and Y axis. It seems so simple in my head but getting it to work in excel is a different beast. Almost considering just drawing it in paint at this point.