7 Display the Grades worksheet. Select the range E7: F33
10.000 and create a Scatter chart. Move the scatter chart to its own sheet named Scatter Chart.
8 Make sure the scatter chart is selected. Type
6.000
Attendance-Final Average Relationship as the chart title, typePercentage of Attendance as the primary horizontal axis title, and type Student ' s Final Average as the primary vertical axis title.
9 Make sure the scatter chart is selected. Apply these
6.000 settings to the vertical axis of the scatter chart: 40 minimum bounds, 100 maximum bounds, 10 major units, and a number format with zero decimal places.
10 Make sure the scatter chart is selected. Apply these
6.000 settings to the horizontal axis: 40 minimum bounds, automatic maximum bounds, automatic units.