Using Microsoft Excel to Make Scatter Plots
by Mark
Paczkowski - 2004 |
1. After opening Microsoft Excel, you will see columns and rows.
2. Enter your x-axis data in the first column.
3. Enter y-axis data in the next column.
4. Select (highlight) both your x and y data. |
5. Go up to Insert, then "Chart…" to open chart
wizard. |
![](Excel_1.jpg) |
6. Select for "Chart Type", "XY (Scatter)".
7. Next, on Chart sub-type, select the top chart that has no
lines, and click Next.
8. Click Next again. |
![](Excel_2.gif) |
9. Enter the chart title along with your X and Y axes
labels. (put units in parenthesis)
9a. Select Gridlines tab 9b. Select Major Gridlines on both axis
|
![](Excel_4.gif) |
![](Excel_5.gif) |
10. Click Next.
11. Click on
"As new sheet" and click
Finish.
|
![](Excel_6.gif) |
12.
Right click on any data point -
this should highlight all the data points
and select "Add Trendline…"
|
![](Excel_7.gif) |
13. Select
"Linear" for a line or
"Polynomial" for a curve.
|
14. Click
Options tab
and check t he last three check boxes. Select
OK |