≡ Menu

Creating multiple y axis graph in excel 2007

Ok this was annoying to figure out so here you go.
I was trying to create 2 axis graph, or chart, in Excel since the relationship of the data was not very good. one was in the tens and the other was in the thousands.
First create a graph using your data and select the type you like. in our case it was a 2 line graph.

then right click on the smaller graph, the blue one in our case, and select the “Format Data Series…”

Then we get a popup window for the series options with the ability to change the series axis.

We select the Secondary axis option and close the window using the Close button.
The graph will update and set for 2 Y axis display.

P.S. the process can be repeated for more lines and more Y axis.

{ 97 comments… add one }

  • Mark B 15/07/2011, 6:37 am

    Awesome, thanks! Saved me tons of time!

  • Web Reviewer 28/07/2011, 12:59 pm

    For Multiple Y Axes in Excel, try Multy_Y or EZplot at http://www.OfficeExpander.com

    There is a demo version for you to try.

    Cheers

  • KS 06/08/2011, 2:23 am

    Thanks a lot! So simple, yet I wasted far too much time on this!

  • Rita 18/08/2011, 6:05 am

    Thank you. As noted in a previous comment, this saved me a lot of time and was much easier to do than in Excel 2003.

  • Paul 02/09/2011, 12:48 am

    But more than 2 y axis is not possible with excel 2007, If you know how to have more than two y axis in excel pl let me know

  • Raghav 07/09/2011, 5:45 pm

    Great help Man!!! Simplified the entire process. Thumbs up!!!

  • Madison 12/09/2011, 7:43 am

    this seriously just saved my life i was trying to figure this out for a good hour and the project is due tomorrow i LOVE you!!!!!!!!!!!!

  • Bill 13/09/2011, 2:42 am

    So, what do you do if the Plot Series On section is grayed out? I am trying to re-use a chart someone else created, and I am assuming I need to specify something in the series in order to pick the primary or secondary axis.

  • Bill 13/09/2011, 2:44 am

    Never mind, figured it out… The other series was not grayed out, so I was able to plot it on a different axis…. A joy to figure out, nonetheless.

  • Kmac 16/09/2011, 6:03 am

    Thanks – saved me time as well. Was getting a bit frustrated.

  • niroshaa 22/09/2011, 4:56 am

    Awesome. Thanks a bunch

  • Hanmant 09/10/2011, 6:40 pm

    Good Information. Many thank and saved lot of time.

  • Rob 12/10/2011, 10:51 am

    Thanks! This was easy to follow and saved me time.

  • Steve 18/10/2011, 8:50 am

    Thank you, this was awesomely helpful and saved a lot of mucking around!

  • Web Reviewer 26/10/2011, 8:33 pm

    Paul, you can plot more than 2y axes in Excel using Multy_Y or EZplot for Excel at http://www.OfficeExpander.com

    There is a demo version for you to try.

    Cheers.

  • Ryan bell 28/10/2011, 3:08 am

    dude!! this saved me so much time i love u bra!! this was so wicked !! imma go know but man i love u !!

  • Tom Earl 04/11/2011, 6:13 am

    how do I make Multiple categorys (Axis Labels) in a line chart
    what I have is multiple programs that I want to trend but in the lable axis categorys only let me list one form of data

  • aa 21/11/2011, 3:38 pm

    Terrific! I love when a quick google search turns up exactly what I need.

  • Naz 08/12/2011, 4:46 am

    Bill, how did you get it to not be ‘greyed out’ any longer?!?!?!?! Mine is greyed out?!?!

  • Yuval Ararat 08/12/2011, 11:43 am

    Naz, it seems he used the other series. he didn’t get it un-greyed.

  • Pankaj 02/01/2012, 9:58 pm

    Very good information. Thank you so much.

  • Joe 12/01/2012, 11:18 am

    Thanks! Saved my day at work….

  • emil... 25/01/2012, 7:48 pm

    thanks man you are the best …. !!! you save me for my project !!!

  • diffeomorfisme 17/02/2012, 7:39 pm

    bedankt. heb ik al te veel tijd aan dit domme ding verspild …

  • Pradeep 21/04/2012, 3:41 pm

    Thanks you verymuch for the info.

  • Ravi 14/05/2012, 8:35 pm

    Thank you. I was checking for this since a hour

  • jenn 21/05/2012, 7:33 am

    Thank you sooo much, i wasted too much time trying to figure out something so simple. thank you for taking the time to explain exactly what i needed!

  • ooi 08/06/2012, 1:43 am

    Thank you! :)

  • Reduan Khan 12/06/2012, 7:47 pm

    Thanks a lot mate :-)

  • Oscar Soze 26/06/2012, 6:17 pm

    Exactly the instructions I needed. Thanks!

  • Vaibhav jain 23/08/2012, 12:56 am

    Great info !!
    I want to create multiple y axis chart in excel 2007. office expander is charging a lot of money for that add on. Is there any other way i can do it. Thanx in advance

  • Yuval Ararat 23/08/2012, 1:09 am

    Not that i know of. that is probably why they are happy to charge you the ridiculous amount of money they do.

  • Binny 25/08/2012, 7:09 pm

    Great Help!!!! I see a lot of ppl saved time like I did….Thanks!!!

  • Wendall 02/10/2012, 5:38 am

    Vaibhav,
    I noticed that the multiple Y axes software for Excel (Multy_Y) is currently showing as 50% off at http://www.OfficeExpander.com
    Maybe this will help. I don’t know of any other way to produce these charts in Excel.
    -Wendall

  • sathya 23/10/2012, 2:55 am

    thankx for the simple explantion. it saved lot of time….

  • Pat 01/11/2012, 11:19 pm

    You are the greatest. Saved me a lot of time. Pat Harrison.

  • Rohit 14/11/2012, 6:20 am

    Thanks for your simple explanation. Didn’t think I’d ever be able to do this and you showed me how in 30 seconds. Really, truly, made my day.

  • Cheers 22/11/2012, 4:18 am

    Thank you! This was very helpful.

  • CGervais 13/02/2013, 7:19 pm

    This was incredibly helpful! Thank you.

  • RADMAN 14/02/2013, 6:58 pm

    You can create 2 seperate graphs into Excel, set their plot area to No fill (Format plot area), then remove all axis that you don’t want to overlay from the second graph when you move it on top of the 1st. You should be able to see 3 set of data refering to 3 seperates Y axis scales (3rd one have to be edit from text with font size to match the original scale) Mine worked just great; I wish I could paste this on this website… RAD

  • Jani Balani 04/03/2013, 11:58 am

    I found this really helpful. Thank you so much.

  • Chris 09/04/2013, 1:24 am

    So now you have what looks like intersecting line series, which is not the intention. Sometimes the scale difference can be overcome by expressing as percentages of final figures or totals, depends if u really need to see original figures or not. You could also try a log scale, comparing rates of change instead of comparing raw numbers on graph. There are many ways to look at the numbers using a graph, without messing up perceptions of the data.

  • Vinay 24/04/2013, 10:04 am

    Thanks a lot…… i wasted atleast an hour to get this… appreciate it

  • Rao 14/06/2013, 5:27 am

    gets screwed up if x-axis is log. at least it seems so when i tried.

  • Liz 24/02/2014, 8:55 pm

    This was just what I was looking for
    Thanks

  • Dino 26/02/2014, 10:55 am

    what should we do if we want more that two y axis? When I try to make a 3rd y axis as a secondary axis, it still plots the data with my existing y axis. Appreciate if you can help me out.

  • MOFAGHAN 22/04/2014, 4:25 am

    thanx a lot man…u saved my times!

Leave a Comment