THANK YOU, spent far too long trying to figure out how to do this! Your video is perfect and I managed to do exactly what I needed for my assessment. You're amazing.
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.
@@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.
@@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!
@@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.
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
THANK YOU, spent far too long trying to figure out how to do this! Your video is perfect and I managed to do exactly what I needed for my assessment. You're amazing.
you did great, short, simple, clear, scientic, Thnak you
Very easy to understand, love it. Thank you!
Thank you so much @Laura Smith. Your excel expertise are way too great. So happy that I learnt something today because of you. ❤
Thank you so much , you saved me from wasting hours and hours of hard work
Really Useful... thanks 🙏
Very helpful with simple method great 👍
This helped me so much, thank you!!
Thank you so much
Thanks a lot… This is so much better than other videos I’ve seen so far
Incredibly clear and helpful. Thank you so much!
thanks so much for this!!!!
The format data series never shows up for me
Thank you So Much Laura Ma'am..
Very helpful thank you
This helped me out so much. Thank you!
So helpful! Thank you
Thanks this was very helpful!
Thanks a lot
U r awesome
This was great but when I right-clicked nothing came up - no options at all. No alternative axis choice. Ideas?
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.
@@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.
@@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!
@@Brandi.Nicole I'm glad you got your research paper sorted! Thank you for the advice regarding the student version too. Thank you.
@@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.
nothing clear big dislike