PRDV007: Spreadsheets III: Presenting Data

The charts we have created up to this point have been added to, or embedded in, an existing worksheet. Charts can also be placed in a dedicated worksheet called a chart sheet. It is called a chart sheet because it can contain only an Excel chart. Chart sheets are useful if you need to create several charts using the data in a single worksheet. If you embed several charts in one worksheet, it can be cumbersome to navigate and browse through the charts. It is easier to browse through charts when they are moved to a chart sheet because a separate sheet tab is added to the workbook for each chart. The following steps explain how to move the grade frequency distribution chart to a dedicated chart sheet:

1. Click anywhere on the Final Grades for the Class chart on the Grade Distribution worksheet.
2. Click the Move Chart button in the Design tab of the Chart Tools set of commands. This opens the Move Chart dialog box. You can use this dialog box to move the chart to a different worksheet or create a dedicated chart sheet.
3. Click the New sheet option on the Move Chart dialog box.
4. The entry in the input box for assigning a name to the chart sheet tab should automatically be highlighted once you click the New sheet option (see Figure 11 Moving a Chart to a Chart Sheet). Type Class Grades. This replaces the generic name in the input box.
5. Click the OK button at the bottom of the Move Chart dialog box. This adds a new chart sheet to the workbook with the name Class Grades.
   
   

Figure 11 Moving a Chart to a Chart Sheet

Figure 12 Chart Sheet Added to the Workbook shows the Final Grades for the Class column chart in a separate chart sheet. Notice the new sheet tab added to the workbook matches the tab name entered into the Move Chart dialog box. Since the chart is moved to a separate chart sheet, it no longer is displayed in the Grade Distribution worksheet.

Figure 12 Chart Sheet Added to the Workbook