How to Create Scatter Graphs
Scatter graphs (also called XY charts) work well for measuring "cause and effect." For example, let's say that after one pound of special soil mixture was used, a patch of grass grew 10 inches in one month. Then in the following month, after 3/4 of the same mixture was used, the grass only grew five inches. Graphing this information may be helpful in determining the maximum affect of special soil compound used and grass growth over a period of time. Scatter graphs can be very useful to scientists and engineers; however, they can also be created by anyone who wants to measure the results of various conditions over a set time frame.
Other People Are Reading
Instructions
-
-
1
In a new workbook in Excel, create a spreadsheet like the one shown here. In cells A1 through A12, Dew points are listed from 65 to 75; and in cells B1 through B12, Heat Index of 90 with the listed Dew point has a temperature variation.
-
2
Go to the menu bar and click on "Insert" and then choose "Chart." (NOTE: Or use the chart icon as a short-cut if it is accessible from the menu bar.)
-
-
3
Choose the "XY(Scatter)" chart from the Chart Type list box. It is accessible from the "Standard Types" tab.
-
4
To preview the chart, click on the "Press and Hold to View Sample" button. Click "Next."
-
5
Confirm the data and then click "Next."
-
6
Select the Titles tab and type in a name for the chart and then enter short descriptions for the "X and Y Axis Values." Click "Next."
-
7
Choose "As Object In" as the option selection and select "Sheet1" from the drop-down list box. Next, click "Finish." (NOTE: You may elect to place the chart in another worksheet within the workbook. If so, select "As New Sheet" as the chart location.)
-
8
To revise the chart, click on it and the "Chart" menu will appear in the toolbar. Select your desired option from "Chart Type," "Source Data," "Chart Options," "Location," "Add Trendline" or "Add Data."
-
1
Tips & Warnings
Don't be afraid to get creative in using scatter graphs, even if it is on a smaller scale. For instance, you may want to measure how a product works based on how you use it and under seasonal or other conditions.
