Excel Graphing help

I didn't know what stack exchange site to put this on, so I put it here. I am trying to determine if there is a correlation between the size of a school and the major that the school specializes in.

In order to do this, I programatically collected and analyzed data. In o开发者_运维知识库rder to make my report, I need to make a few graphs in excel, but I have no clue how to do this.

What I'm looking for is a scatter plot, with quantitative values on the Y-Axis (the school size) and qualitative values on the X-Axis, I would like there to be every major listed out (kinda like a bar graph). From there, I want to plot a point above the major that a school specializes in; and have that point be as high as its student size.

Any help?

Edit:

Here is my sample data set. I want it to have categories that are to the right of the data, and points on the graph that correspond.

When you say "correlation" between X and Y, I think regression.

I would recommend doing an X-Y scatter plot and asking Excel to add a trend line. Not only will you get a least squares fit for the "best" line for your data, you'll get the correlation coefficient that tells you whether or not there's a relationship. The correlation coefficient ranges from -1 to +1; the closer your correlation coefficient is to 1.0, the better the relationship.