Excel question, adding Y axis to far right border

[leonardmp92]

Hello,

I have an excel chart, but want the y axis (% reading in this case) to be on the far right axis, not left axis like typically used. How do I do this?

Thanks!

 

[Yek]

There should be a setting in the chart prop's

 

[leonardmp92]

Where pls? Pls walk me thru the steps, I could not find anything except being able to set an axis on the left side, not right side.

 

[KSoD]

If i am not mistaken dont you have to identify the row or column? If so you would have to do a formula in that row or column to produce the % right? So if that is the case why wouldnt you jsut put that forumula in the column to the left?

If you dont put in the forumla why not just put it in where you want it to generate the info where you want it instead of trying to force the software to do something it cant. Even a google search provides this info....

creating right sided axis in excel - Google Search

 

[Yek]

Chart props was just a guess, personally I don't have a copy of Excel on this machine so I can't check for you. I echo Mak, try a Google search.