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 .