2 y axis on the chart

[kylefoley76]

how do i make a chart with two y axis. i'm using excel for mac 2011 so it's a little different.

=SERIES(,Sheet2!$A$2:$A$300,Sheet2!$I$2:$I$300,1)

I need to find someway to put the second value for the y axis in that formula. the actual data is in Sheet2!$j$2:$j$300

 

[kylefoley76]

any ideas here? i need to rewrite that formula so that there's two axes in it

 

[Michael M]

I don't know if it's much help in your case, but have a look here for step by step for 2 Y axis

http://www.lytebyte.com/2009/02/24/how-to-create-excel-chart-with-2-y-axis-or-x-axis/

 

[kylefoley76]

thank you for helping me. i've seen that article before. it doesn't apply to macs. in mac you need to enter the formula in the formula bar

 

[Michael M]

Ok, sorry.....don't have a clue on Macs.

 

[kylefoley76]

Re: 2 y axes on the chart

any ideas on this one?

 

[kylefoley76]

hopefully i'll have more success on a weekday