Creating multiple y axis graph in excel 2007

by yuval on 16/09/2008

Hello there! If you are new here, you might want to subscribe to the RSS feed for updates on this topic.

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.

Share and Enjoy:

Tagged as: Graph, Line chart, Microsoft Office Excel, Multiple Axis, Y axis

{ 3 trackbacks }

bjornstar: 31/01/2009 at 9:53 pm
excel multiple axis graph - Web - WebCrawler: 05/11/2008 at 1:59 am
creating line charts in 2007 with multiple - Dogpile Web Search: 27/04/2009 at 10:40 pm

{ 27 comments… read them below or add one }

sk 12/12/2008 at 4:07 am: Thank you so so much…saved me so many hours of looking around and exploring options.
Sanford Silverburg 16/12/2008 at 2:55 am: I need to create a y-axis with two sets of values, from the x-axis from 0 with intervals of .5 to 20 with intervals thereafter of 10. Need help.
Tess 31/12/2008 at 2:10 am: You’re wonderful! I tried figuring this out using the Excel help and the options they listed were not even visible. Your way took mere seconds!

THANK YOU!
Anonymous 27/01/2009 at 5:42 pm: thanks alot.. have been trying to find out since 3 days…s
Mr.Chemic 31/01/2009 at 8:48 am: Super! Very good work. This method is very important for me. Now I am trying to draw secondary axis in MS Excel 2003. For Excel 2007 is very easy! Thank you again!
TF 03/02/2009 at 5:51 pm: This is so easy!! Thanks, you saved me so much time and heartache
Anonymous 04/02/2009 at 12:23 am: Thankyou Dear, It saved my exploring the solution on net
Anonymous 27/02/2009 at 11:16 pm: Thank you so much! I struggle to find things in 2007 and was tearing my hair out over this.
Jaimie 10/03/2009 at 7:10 am: I have another question regarding this — Can I have the first axis Y data be in bars and the second axis data be in lines?

Thanks
Jaimie 10/03/2009 at 7:11 am: I have another question regarding this….Can I have the first axis Y data be in bars and the second axis Y data be in lines?

Thanks
yuval 10/03/2009 at 1:13 pm: Yes.
In the second photo you will find the “Change Series Chart Type…” (3rd option from the top after you right click the series). Click on it and it will let you change the series to any chart type that you want.
But not all of the Chart Types work correctly so be careful in the type you select and validate that nothing was omitted from the results.
Cheers!
Anonymous 23/03/2009 at 11:32 pm: Thanks alot, this saved me alot of time and stress
John doe 19/05/2009 at 1:46 pm: THANK YOU SO MUCH! you saved me so much time
Siddo 20/05/2009 at 3:57 am: Thanks for taking the time to share!
Lacuzygirl 02/06/2009 at 8:37 am: Thanks so much you’re a life saver with this one! it actually helped me get my project report off the ground.
Emily 18/07/2009 at 1:08 am: Thanks Yuval. Super easy, and your instructions were so much more easy and straight forward than the other sites I browsed to figure this out.
yuval 20/07/2009 at 5:05 pm: Happy i could help
Dape 25/07/2009 at 10:36 am: Can another x axis con the top be created? I simply can’t get it right… Thank you!
yuval 28/07/2009 at 10:19 am: AFAIK there is no way.
Jingle 11/08/2009 at 8:16 pm: COOL… thanks… it helps… lesson learned!!
sonja 28/08/2009 at 12:04 am: Thank you for posting this!!!!
Eleni 22/09/2009 at 7:56 pm: Thx!But I don’t think that the procedure can be continued for more than 2 axis..for example I haven’t find a way to make 3 or 4-y axis..If you have any idea please let me know!!
John 30/09/2009 at 6:14 am: Thanks! Helped a lot!
Lilly 20/10/2009 at 9:39 am: well this helped me if i was ever to do this on excel but it doesn’t explain or show me how to do this on paper. You reallly helped a lot. thanks!! No
dennis 27/10/2009 at 2:21 pm: this info really helped me so much … i will refer this to my friends
barry 25/11/2009 at 8:46 pm: how to do 3 y axis , 1 on left two on right
yuval 27/11/2009 at 9:43 am: Dont know. have never been able to go beyond the 2 and i think you cannot since there is not way to have 2 scales on the same axis.
Sorry.