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.
bjornstar wrote,
| Link | January 31st, 2009 at 9:53 pm
excel multiple axis graph - Web - WebCrawler wrote,
| Link | November 5th, 2008 at 1:59 am
sk wrote,
Thank you so so much…saved me so many hours of looking around and exploring options.
| Link | December 12th, 2008 at 4:07 am
Sanford Silverburg wrote,
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.
| Link | December 16th, 2008 at 2:55 am
Tess wrote,
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!
| Link | December 31st, 2008 at 2:10 am
Anonymous wrote,
thanks alot.. have been trying to find out since 3 days…s
| Link | January 27th, 2009 at 5:42 pm
Mr.Chemic wrote,
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!
| Link | January 31st, 2009 at 8:48 am
TF wrote,
This is so easy!! Thanks, you saved me so much time and heartache
| Link | February 3rd, 2009 at 5:51 pm
Anonymous wrote,
Thankyou Dear, It saved my exploring the solution on net
| Link | February 4th, 2009 at 12:23 am
Anonymous wrote,
Thank you so much! I struggle to find things in 2007 and was tearing my hair out over this.
| Link | February 27th, 2009 at 11:16 pm
Jaimie wrote,
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
| Link | March 10th, 2009 at 7:10 am
Jaimie wrote,
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
| Link | March 10th, 2009 at 7:11 am
yuval wrote,
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!
| Link | March 10th, 2009 at 1:13 pm
Anonymous wrote,
Thanks alot, this saved me alot of time and stress
| Link | March 23rd, 2009 at 11:32 pm
creating line charts in 2007 with multiple - Dogpile Web Search wrote,
| Link | April 27th, 2009 at 10:40 pm
John doe wrote,
THANK YOU SO MUCH! you saved me so much time
| Link | May 19th, 2009 at 1:46 pm
Siddo wrote,
Thanks for taking the time to share!
| Link | May 20th, 2009 at 3:57 am
Lacuzygirl wrote,
Thanks so much you’re a life saver with this one! it actually helped me get my project report off the ground.
| Link | June 2nd, 2009 at 8:37 am