Moving a Chart to a Different Sheet
In Excel 2007, charts always start out as objects embedded in a worksheet. However, you
might want to display a chart on its own full-page chart sheet.
There are two options for moving a chart:
■ Choose the Move Chart icon at the right edge of the Design ribbon.
■ Right-click any whitespace near the border of the chart and choose Move Chart.
Either way, the Move Chart dialog appears, offering the options New Sheet and Object In.
The Object In drop-down lists all the worksheets in the current workbook. The New Sheet
option allows you to specify a name for a new sheet. (See Figure 1.24.)
1
Chapter 1 Introducing Charts ...