Resistance Posted September 30, 2012 Share Posted September 30, 2012 How do I create a XY scatter graph showing the relationship between two things. I'm using the newest version of Excel and I think that the oversimplification has made it impossible.Any ideas? Link to comment Share on other sites More sharing options...
Mojo_Monkey Posted September 30, 2012 Share Posted September 30, 2012 Do you mean Excel from Office 2010 or is there a newer version?Well for 2010 if you mean some thing like this: This is the the relation between RBS (red blossom seeds if you were wondering) and catchesYou highlight the cells...in this case I did from B2 to H4 it should make a rectangle around them, then you go to the insert tab and there is a sub-tab called "charts" there is a scatter plot button there, click it and you should be set. Link to comment Share on other sites More sharing options...
Resistance Posted October 2, 2012 Author Share Posted October 2, 2012 Office 2011 for mac. I did try making a chart, I'm trying to show the relationship between GDP and Population, and later GDP and life expectancy and so on. [/img] I would like GDP on the x-axis and population on the y-axis. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now