9.2 Creating a Scatter Plot

1. Select the cells in the Columns Eruptions and Waiting.
2. Go to the Insert tab. Select Scatter in the Charts ribbon. Select the leftmost chart in the top row by clicking on it (Figure 9.1).

Figure 9.1: Scatter option in the Chart ribbon of the Insert tab.

The resulting plot is shown in Figure 9.2. The Chart Design tab shows that the leftmost diagram style is selected (Style 1).

Figure 9.2: Scatter plot created.

3. For the title, replace Waiting with Old Faithful Data.
4. Click Add Chart Element > Axis Title > More Axis Title Options. This will add an automatic x-axis title and y-axis title.
5. Click the x-axis title and replace it with Duration of Eruptions (in Minutes).
6. Click the y-axis title and replace it with Time Until the Next Eruption (in Minutes).
7. RIGHT-click on the horizontal axis and then select Format Axis to change the axis format in the plot. Set the Minimum Bound as 1. Adjusting the axis removes
8. RIGHT-click on the vertical axis and then select Format Axis to change the axis format. Set the Minimum Bound as 30 and Maximum Bound as 100.

The adjusted box plot is shown in Figure 9.3.

Figure 9.3: Adjusted scatter plot.