Creating multiple y axis graph in excel 2007

by Yuval Ararat on 16/09/2008

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.

{ 96 comments… read them below or add one }

Mark B July 15, 2011 at 6:37 am

Awesome, thanks! Saved me tons of time!

Web Reviewer July 28, 2011 at 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 August 6, 2011 at 2:23 am

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

Rita August 18, 2011 at 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 September 2, 2011 at 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 September 7, 2011 at 5:45 pm

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

Madison September 12, 2011 at 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 September 13, 2011 at 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 September 13, 2011 at 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 September 16, 2011 at 6:03 am

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

niroshaa September 22, 2011 at 4:56 am

Awesome. Thanks a bunch

Hanmant October 9, 2011 at 6:40 pm

Good Information. Many thank and saved lot of time.

Rob October 12, 2011 at 10:51 am

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

Steve October 18, 2011 at 8:50 am

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

Web Reviewer October 26, 2011 at 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 October 28, 2011 at 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 November 4, 2011 at 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 November 21, 2011 at 3:38 pm

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

Naz December 8, 2011 at 4:46 am

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

Yuval Ararat December 8, 2011 at 11:43 am

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

Pankaj January 2, 2012 at 9:58 pm

Very good information. Thank you so much.

Joe January 12, 2012 at 11:18 am

Thanks! Saved my day at work….

emil... January 25, 2012 at 7:48 pm

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

diffeomorfisme February 17, 2012 at 7:39 pm

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

Pradeep April 21, 2012 at 3:41 pm

Thanks you verymuch for the info.

Ravi May 14, 2012 at 8:35 pm

Thank you. I was checking for this since a hour

jenn May 21, 2012 at 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 June 8, 2012 at 1:43 am

Thank you! :)

Reduan Khan June 12, 2012 at 7:47 pm

Thanks a lot mate :-)

Oscar Soze June 26, 2012 at 6:17 pm

Exactly the instructions I needed. Thanks!

Vaibhav jain August 23, 2012 at 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 August 23, 2012 at 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 August 25, 2012 at 7:09 pm

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

Wendall October 2, 2012 at 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 October 23, 2012 at 2:55 am

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

Pat November 1, 2012 at 11:19 pm

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

Rohit November 14, 2012 at 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 November 22, 2012 at 4:18 am

Thank you! This was very helpful.

CGervais February 13, 2013 at 7:19 pm

This was incredibly helpful! Thank you.

RADMAN February 14, 2013 at 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 March 4, 2013 at 11:58 am

I found this really helpful. Thank you so much.

Chris April 9, 2013 at 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 April 24, 2013 at 10:04 am

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

Rao June 14, 2013 at 5:27 am

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

Liz February 24, 2014 at 8:55 pm

This was just what I was looking for
Thanks

Dino February 26, 2014 at 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.

Leave a Comment

{ 3 trackbacks }

Previous post:

Next post: