Back
Use Excel to Make a Scatter Plot
> ... Math > Excel > Use Excel to Make a Scatter Plot

Excel is a powerful tool for storing data and making graphs. The following video demonstrates one way to make a scatter plot in Excel. A scatter plot is a graph that just plots the data points. It doesn’t connect them with a line.

How to Make a Scatter Plot in Excel

The basic steps to make a scatter plot in Excel:

1. Highlight data you want to plot.
2. Go to the Insert tab.
3. Find the Charts section.
4. Select the scatter plot icon.
5. Edit ranges, axis titles, chart title, and anything else you want to adjust.

### Practice Problems

The following table summarizes data on the number of hours that students spent studying and the scores that they earned on their exams.

Hours Studied Exam Score
7.5 68
9.5 92
6.75 79
1.75 36
6 72
9 95
7.5 86
7 95
8.5 73
0.75 48

Use Excel to create a scatter plot of these data, where the time spent studying is on the x-axis (the horizontal axis) and the test score is on the y-axis (the vertical axis). (
Solution
Solution: Details:
1. Type the information into Excel: 2. Highlight both columns (Tutorial): 3. Click Insert, then Chart, then X Y (Scatter) 4. You now have a chart!

Note: You can make adjustments to your chart if you would like. Try adding labels, colors, a legend, etc. by clicking on the Chart Design tab in Excel.
)

## Need More Help?

1. Study other Math Lessons in the Resource Center.
2. Visit the Online Tutoring Resources in the Resource Center.