Thursday, June 23, 2011

How to Create a Scatter Plot Graph


1. Enter column headers in row 1. Put the variable that you want on the X axis in cell A1, and the variable you want on the Y axis in cell B2. For example, if you are making a scatter plot of height and weight, enter 'Height' in A1 and 'Weight' in B1.
2. Enter data. In our example, enter the height and weight of each person in a row, with height in column A and weight in column B.
3. Click 'insert,' 'scatter,' and then the 'graph' on the upper left. This is a scatter plot, but you may wish to modify it.
4. For a more standard scatter plot layout, choose 'layout 1' in the design menu, then click on the X-axis title and type in 'Height.' Click on the Y-axis title and type in 'Weight.' Delete the little box on the right that says 'weight.' Then click on the title of the graph and enter something appropriate, such as 'Height and weight.'

Blogger news