Risk/Return scatter chart - efficient frontier

Hi,

I'm trying to create an 'efficient frontier chart' using portfolio returns and their risk (st.dev). Whenever I plot a scatter chart, I get the 2 variables as different series. I need them to be each on the same plot point but I cannot figure out how to do this. Please see the link for a picture of what I am trying to achieve. Any help would be fantastic!

http://www.smart401k.com/Content/ima...r.png?sfvrsn=0

Thanks!

Sorry to waste your time, I managed to figure it out since you posted that. I had the axis the wrong way around, leading me to think the chart was wrong. Switched the axis and all is as it should be. Thank you though!