Ok this was annoying to figure out thus i had to share this out.

I was trying to create 2 y axis graph, or chart, in Excel since the scale of the 2 data sources was not easy to put in one graph, one was in the tens and the other was in the thousands, i had to work a little harder.

First step is to create a graph using your data and select the type of graph you would like. in our case i went with dual line graph.

Next step was to change the scale so right click on the smaller line chart, the blue one in my case, and select the “Format Data Series…”

Then you get a popup window for the series with an option to change the series axis to “Secondary Axis”, choose that!

When select the Secondary axis option and close the window using the Close button the graph will update and a new series will appear on the graph..

You have now got a Multiple Y axis graph displaying.

Wasnt too hard now was it?

P.S. the process can be repeated for more lines and more Y axis but i am not sure how useful that data will be.

Copyright secured by Digiprove © 2016 Yuval Ararat
Thank you so so much…saved me so many hours of looking around and exploring options. 🙂

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.

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!

thanks alot.. have been trying to find out since 3 days…s

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!

This is so easy!! Thanks, you saved me so much time and heartache

Thankyou Dear, It saved my exploring the solution on net

Thank you so much! I struggle to find things in 2007 and was tearing my hair out over this.

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

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

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!

Thanks alot, this saved me alot of time and stress

THANK YOU SO MUCH! you saved me so much time

Thanks for taking the time to share!

Thanks so much you’re a life saver with this one! it actually helped me get my project report off the ground.

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.

Happy i could help 🙂

Can another x axis con the top be created? I simply can’t get it right… Thank you!

AFAIK there is no way.

COOL… thanks… it helps… lesson learned!!

Thank you for posting this!!!!

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!!

Thanks! Helped a lot!

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

this info really helped me so much … i will refer this to my friends

how to do 3 y axis , 1 on left two on right

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.

thank youuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu

you saved somone’s life buddy 🙂

Love you too mate!

Thank u so much!!!! Excelent explanation!!

I ve been looking for this answer for so long!

thank you for your information. it helps me a lot!

Thank you very much short and sweet.

Thanks

Thanks,

With screen shot it helps a lot

Hi yuval: how can i do this using bar graph? i tried but it doesnt work. Thank you.

In Outlook 2007 I think you cannot do this with any of the 3D graphs. The “Plot Series On: Secondary Axis” option simply does not appear after you select “Format Data Series.” Works fine in 2D.

thanx a lot for saving my time. God bless you

I am trying to do this from a pivot table and not having any luck… assistance would be awesome please

I never tried using a pivot table to achieve a graph so am not sure about the problems nature.

Is there a way you can share your sheet so I can see the problem?

You are genius! What I would do without you!?! Thank you SO much!

Yes, you can create 3 (or more) Y axes in Excel using

Multy_Y or EZplot. Try the demo version at

http://www.OfficeExpander.com

This helped me so much! Thank you <333

Hi,

I’m trying to create a secondary axis on a chart that has been mad from a pivot table, nut when I go to select “secondary axis” in the series option, the radial is not selectable. Please let me know what I need to do? I am using Excel 2010

Thanks,

Sebastian

Thanx, thanx, thanx .. this is really useful .. I was looking for free OriginLab software in the internet to create multi-axes graphs for my project .. but now no need for that software

Do you know a way to associate a data series with a different axis without having to select the data series, e.g. its line or bar, etc.? The problem I run into is that sometimes the data series is not showing due to the scale of the primary axis, and the way I can get to it is to first change the primary axis scale, select the data series I need to change, then using Format Data Series. Then I have to go back and reset the Primary Axis scale. Seems like there should be a way to associate a data series with an axis from the data rather than just from its representation on the chart.

Thanks.

Thank you Yuval, this was very helpful

your welcome Carlos.

You are a force for good in the universe!

Thanks due to ur comment on third axis i could manage to do my presentation and it really helped me

thanks dude god bless ..

Awesome, thanks! Saved me tons of time!

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

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

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.

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

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

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!!!!!!!!!!!!

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.

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.

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

Awesome. Thanks a bunch

Good Information. Many thank and saved lot of time.

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

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

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.

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

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

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

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

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

Very good information. Thank you so much.

Thanks! Saved my day at work….

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

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

Thanks you verymuch for the info.

Thank you. I was checking for this since a hour

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!

Thank you! 🙂

Thanks a lot mate 🙂

Exactly the instructions I needed. Thanks!

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

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

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

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

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

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

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.

Thank you! This was very helpful.

This was incredibly helpful! Thank you.

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

I found this really helpful. Thank you so much.

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.

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

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

This was just what I was looking for

Thanks

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.

thanx a lot man…u saved my times!

Thanks.

This was handy, except Microsoft scales AND adds an offset. This is a problem for my graph of command and output. It gives the appearance of an offset error.

Graphs are for illustration, and Microsoft in an attempt to make things easy makes a graph that will confuse and mislead my audience. I wish I could set offset to zero. (I am surprised that would not be the default.) Two input boxes, one for scale (default to one), and one for offset (default to zero) would be better.

Microsoft seems to put very little thought into some of these features. Histograms are also goofed up.

Thanks so much! This is such a great help. Cheers.

I often visit your site and have noticed that

you don’t update it often. More frequent updates will

give your blog higher rank & authority in google.

I know that writing articles takes a lot of time, but you can always help yourself with miftolo’s tools which will

shorten the time of creating an article to a few seconds.