Use Excel To Make A Scatter Plot

Home » How To Make A Scatter Plot In Excel » Use Excel To Make A Scatter Plot

Maybe your like

Home Math Writing Language Skills Tutoring Introduction to Graphs: 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.

Video Source (05:26 mins) | Transcript

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. Click on the scatter plot icon.
  5. Edit ranges, axis titles, chart title, and anything else you want to adjust.

Additional Resources

  • Khan Academy: Constructing a Scatter Plot (02:31 mins, Transcript)

Practice Problems

  1. The following table summarizes data on the number of hours that students spent studying and the scores that they earned on their exams.
    2. 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).

View Solutions

Solutions

    This is a scatter plot with x-axis from zero to ten that represents hours studied and y-axis from zero to a hundred that represents the Exam score. The points on the scatter plot are (0.75, 48), (1.75, 36), (6, 72), (6.75, 79), (7, 95), (7.5, 68), (7.5, 86), (8.5, 73), (9, 95), (9.5, 92).

    (Written Solution)

  1. Type the information into Excel:

    This is a picture of an Excel spreadsheet. There are two columns. The first has the number of hours studied. The second has the exam score for the corresponding hours.

  2. Highlight both columns (Tutorial):

    This is a picture of an Excel spreadsheet. There are two columns. The first has the number of hours studied. The second has the exam score for the corresponding hours. Both columns have been highlighted.

  3. Click Insert, then Chart, then X Y (Scatter)

    An Excel spreadsheet with columns for hours studied and corresponding exam score. The steps to make a scatter plot are first, click on the “Insert” tab in the Excel menu bar. Second, select “Chart” from the resulting menu. Third, select “X Y (Scatter)” from the next resulting menu.

  4. You now have a chart!

    5. 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.

Tag » How To Make A Scatter Plot In Excel