Jump to content
Sign in to follow this  
Resistance

Excel help: creating a graph

Recommended Posts

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?


qTLQRuS.png

Share this post


Link to post
Share on other sites

Do you mean Excel from Office 2010 or is there a newer version?

Well for 2010 if you mean some thing like this:

 

commoncatchscatter.png

This is the the relation between RBS (red blossom seeds if you were wondering) and catches

You 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.


orlyn.png

youry.png

Share this post


Link to post
Share on other sites

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.


qTLQRuS.png

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.