Datasheet

Chart Sheets
You can move an embedded chart to its own chart sheet, so you can view it by clicking a
sheet tab. When you move a chart to a chart sheet, the chart occupies the entire sheet. If
you plan to print a chart on a page by itself, using a chart sheet is often your better choice.
If you have many charts to create, you may want to put each one on a separate chart sheet
to avoid cluttering your worksheet. This technique also makes locating a particular chart
easier because you can change the names of the chart sheets’ tabs to provide a description
of the chart that it contains.
Figure 1-4 shows a chart on a chart sheet. When a chart sheet is activated, Excel displays
the Chart Tools context tabs, as described in the previous section.
NOTE
Previous versions of Excel have a Size with Window option for charts on a chart sheet.
When this setting is enabled, the chart adjusts itself when you resize the workbook win-
dow (it always fits perfectly in the window). This feature is not available in Excel 2007.
Figure 1-4: A chart on a chart sheet
Chapter 1: Introducing Excel Charts
Part I
13
05_044001 ch01.qxp 8/24/07 8:48 PM Page 13