104 ExcelEXCEL TIPS
Excel has several different built-in chart layouts for making
quick changes to several chart objects at the same time. You can
view a gallery of the chart layouts by clicking the Chart Layouts
button located on the Design tab of the Chart Tools ribbon.
You can change the type of chart displayed by Excel by selecting
a chart and then clicking the Change Chart Type button located
in the Type group of the Design tab in the Chart Tools ribbon.
The Change Chart Type will then display a list of all chart types
and chart templates stored on your computer.
If you want to reuse all of the formatting choices you made for
your chart in future charts, you can save your chart as a template
by clicking the Save As Template button from the Type group on
the Design tab of the Chart Tools ribbon.Now that you’ve formatted the chart, interpret the scatter plot you’ve
created. One of the questions you were asking was What is the relation-
ship (if any) between the average SAT score of a freshman class and its
eventual graduation rate? You can now put forward one hypothesis:
Higher average SAT scores seem to be associated with higher graduation•
•
•
Figure 3-19
Revised
symbols for the
graduation chart