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)
Screen recorder & editor techsmith.z6rjha.net/c/198849...
KZbin SEO www.tubebuddy.com/SHTeach
Software (Microsoft Excel 365 ProPlus)
FOLLOW US
Website toptipbio.com/
Facebook / toptipbio
Twitter / toptipbio
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.

[@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

[@FJervis-h7d]

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

[@Pranjalchoudhary100]

Thanks a lot brother❤

[@sethialok2000]

Many thanks for crisp and to the point guidance!

[@carnivoremike]

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

[@lealeveriza4497]

Very helpful and straightforward. Thank you 👍❤

[@ElyonBeats]

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

[@madalchemist31]

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

[@elvisperez5174]

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

[@daniel4740]

That was freaking awesome! Thank you

[@-propaganda-]

You saved my project!! Thank you!

[@noahcoskun3989]

Great tutorial, thank you sir!

[@P.s_nuel5823]

This was so helpful, thanks a bunch.

[@mimicovers97]

Very helpful, thank you!

[@aaronjudesaldanha5688]

so simply put - many thanks subscribed

[@rupeemaster]

Very helpful! Thank you

[@saurabhsharma9881]

very useful, thanks for creating! :)

[@juliangomez7829]

god bless you, loving and kind soul

[@user-xm2sh4zz6s]

Great Video! Thanks a lot!

[@reececollison5101]

THANK YOU this video is a life saver 🤩

[@mariehuffman9344]

Very helpful; you saved me. Thanks!

[@claudinealary1241]

This was super helpful thank you so much!

[@StevenBradburn]

Glad it was helpful!

[@hzmrrabbi]

Simply Excellent!

[@RossMaynardProcessExcellence]

Brilliant - short sharp explanation. Helped me get it done

[@StevenBradburn]

You're welcome!

[@Artemis49]

Very helpful! Gracias

[@RhodySeth]

Brilliant, thank you much. 😊

[@mabelborst6623]

Great video, saved hours of time

[@loremipsum3625]

thank you very much for your help

[@Skweepz]

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

[@tahoon2009]

simple and easy to understand

[@akbarmuhammad5773]

Terimakasih, berkat anda saya bisa pasang secondary axis

[@RandomGuy0022]

great stuff !!!

[@gretoeflieltsathome7849]

great help!

[@user-gk3ng2br7u]

Thank you!

[@robl417]

Thank you. Very helpful.

[@StevenBradburn]

Glad to hear it!

[@MegaMartin9898]

Tnx, very helpful

[@rajneelnarayan7528]

Thanks mate

[@josephcarey4032]

absolute life saver

[@yogeshprasher691]

Thanks a lot.

[@kds5065]

Thanks! Can't believe I was trouble finding that "secondary axis" radio button to click.

[@fondue542]

Easy to follow and updated, thanks!

[@AndrewPick6]

ty!

[@rfengineering2022]

Thank you

[@gauss8134]

Valeu man! Mto brother vc!

[@matheushenriquebaesso9024]

Thank you manito

[@abdellahmezrari125]

thank you

[@mrhotpatato5990]

YOU ARE THE GOAT

[@ACOGDaBot]

ur a legend!!

[@keerthinidhishetty6464]

This helped

[@MrSadiq01]

Very good

[@kuba2466]

thanks governor

[@linalee6]

thanks

[@unitybro855]

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

[@worst_lofi_rapper4322]

Here after hydraulic drains arta kwstakioi ! Thanks my dear sir

[@Dr_Ahmed_Ali_Saleh]

Thanks

[@ctherats6023]

Brilliant - surgical and specific Thanks !

[@elber83full]

Eres grande

[@soba5904]

I LOVE YOU

[@olaoluwaelegbede3264]

Please, how do you make a trend line for this data ? I'm not talking about for each of the series, I'm talking about a joint trend line for both series. Please, please help, I have an assignment to submit.

[@JGS2295]

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

[@mikemansouri6447]

How do you add labels to each Axis??

[@triconex4816]

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?

[@OnNatoBasketball]

you must be using an app not the website

[@arvindpillai2587]

Right Click on the chart and you will find format series data

[@busyrat6400]

But how can I keep two different bars shown in same chart after ?

[@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?

[@shoolaces88]

right there with you. lol Ironically if you state something blatantly false in the comments you'd have 15 assholes actually responding. Did you ever figure it out??

[@elliedavison445]

My plot series on options are greyed out

[@YourTourAssistant]

NOT GETTING THE PLOT SERIES ON .. Primary or secondary options. chart design is only showing up

[@paulgiulekas7127]

when I follow the secondary axis is grayed out

[@Facelearn]

how to show in a graph, date, time and users accessed on one graph

[@emmanuellopez9934]

My excel doesn’t have any of those options

[@tommyharris5817]

Brill.

[@Lucas-ns9hd]

Thanks. Excel might truly be one of the least user-friendly pieces of software that I have ever used. I should not need an entire course's worth of knowledge to create a chart with two fucking Y axes.

[@Peanuts-9ualw32]

W

[@qrubmeeaz]

Um, sorry but no. This is incomplete. How do I know which graph is primary and which is secondary?

[@modalize]

1:52 thx bye wtf so long

[@user-yq2ug5dt7m]

Thank you!

[@mattiaswahlbin3333]

Thank you

[@keithpicotte1684]

thank you

[@karthiksalian5715]

thanks