make dual 2 y axes on excel graph

its a pretty basic video................but this knowledge took me hell to find it........thanx 4 watching....

Category:

Education

Tags:

• make
• dual
• 2
• y
• axes
• on
• excel
• graph

[hrafatima]

A.a thanks for this.... but u have only two y-axis values ... but i have six y-axis .means ,values of six colums appear on zero.as urs one y-axis value. plz help me.......

[worldizexamadil]

@hrafatima You mean 6 y-axes with one x-axis? That's not possible on one chart, because excel allows only 2 y-axis maximum, default one is primary y-axis and the 2nd one is the secondary y-axis. Alternatively, you may try 3 charts with dual y axes. I hope i answered appropriately.

[worldizexamadil]

No problem guys. I am glad that it was something of help.

[MegaAlfies]

thank you!!!!!!!!!!!!!

[devilndisguise666]

oh my goodness!! that you sooo much!! i read so many articles on this and was feeling pretty useless but none of the articles or even the help section mentions that you have the select the curve itself not the whole plot area or chart area. you just made my life so much easier:D

[G00SE216]

Much appreciated. Thanks for taking the time to make the work day a little easier : )

[jsuneb]

Thanks! Great help!

[Wiitamilk]

Thank you so much!!!! :)

[navylaks2]

I have to make a graph were the there's only one curve but still a dual y-akses how can i do that?

[fenneratron1]

THANKS!!

[samargles]

I'm not sure which stock your monitoring, but i need to invest!!!

[MsWebreviewer]

Yes, you can add more than 2 y-axes in Excel using Multy_Y or EZplot for Excel at OfficeExpander.

There is a nice demo version for users to try. Cheers.

[93erinkelley]

@paddygirl don't feel bad. I couldn't get it to work either. I blame my biology teacher for making me having to make a line graph with multiple x and y axises.