How To Add A Second Y Axis To Graphs In Excel

In this tutorial, I’m going to show you how to add a second Y axis to a graph by using Microsoft Excel. Adding a secondary Y axis is useful when you want to plot multiple data series that are measured on different scales.

HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
Software (Microsoft Excel 365 ProPlus)

FOLLOW US

AFFILIATE DISCLAIMER
Some of the above links are affiliate links, meaning I will earn a commission if a sale is made after clicking on the link.

[FJervis-hd]

This is exactly what I needed for a lab report. Thanks!

[FugIyDuck]

I love you. Mac is very complicated when it comes to excel compared to windows and I was about to go crazy, trying to plot my graph correctly by adding a secondary axis... I've been looking for a solution for hours because the videos I've watched and the instructions I've read simply did not work on my Mac because I either didn't have the options at all or mine were comparably lacking. I've finally finished my assignment and can hand it in. You're amazing

[carnivoremike]

Great video. Short, to-the-point, and very helpful.

[madalchemist]

LOL THANKS THIS CAME IN OUR IGCSE ICT EXAM, PAPER 3, 2023 JUNE, IT WAS ABOUT AVERAGE RAINFALL AND TOTAL SUNLIGHT LOLLLL, THIS VIDEO SAVED MY LIFE

[-propaganda-]

You saved my project!! Thank you! <3

[Skweepz]

Thank you very much. Just saved me like an hour on a lab write up lol

[ElyonBeats]

Thank you! Appreciate the concise and straight-to-the-point nature of this video.

[Harry-vn]

Thanks now I can write my lab report 💯

[elvisperez]

Very helpful!! 👍👍…Thanks for the short video!

[RossMaynardProcessExcellence]

Brilliant - short sharp explanation. Helped me get it done

[lealeveriza]

Very helpful and straightforward. Thank you 👍❤

[worst_lofi_rapper]

Here after hydraulic drains arta kwstakioi ! Thanks my dear sir

[reececollison]

THANK YOU this video is a life saver 🤩

[claudinealary]

This was super helpful thank you so much!

[akbarmuhammad]

Terimakasih, berkat anda saya bisa pasang secondary axis

[GhostsRustyKnee]

Hello! I am trying to do this, however whenever I right click on the line, my only option is "format". It then goes to the overall chart design instead of to the options you show. I'm using the most updated 365 version on Chrome, does it not have this feature?

[triconex]

When I right click, there's no option as "format data series". Im using excel online from office 365. How do I enable the format data series option?

[unitybro]

Hi Steven, If three rows will come and we want to compare any specific two rows then what we need to do?

[brucefranken]

But how do you put an identical copy of the Y-axis on both left and right?

[JGS]

How do I plot a series on a Primary Y axis but Secondary X axis?