Datasheet

Home➪Clipboard➪Paste (or press Ctrl+V). The new location can be in a different work-
sheet or even in a different workbook. If you paste the chart to a different workbook, it will
be linked to the data in the original workbook. Another way to move a chart to a different
location is to choose Chart Tools ➪Design➪Location➪Move Chart. This command displays
the Move Chart dialog box, which lets you specify a new sheet for the chart (either a chart
sheet or a worksheet).
Converting an Embedded Chart to a Chart Sheet
When you create a chart using the icons in the Insert➪Charts group, the result is always
an embedded chart. If you’d prefer that your chart be located on a chart sheet, you can eas-
ily move it.
To convert an embedded chart to a chart on a chart sheet, select the chart and choose
Chart Tools➪Design➪Location➪Move Chart to display the Move Chart dialog box shown in
Figure 1-16. Select the New Sheet option and (optionally) provide a different name for the
chart sheet.
Figure 1-16: Use the Move Chart dialog box to move an embedded chart
to a chart sheet (or vice versa).
To convert a chart on a chart sheet to an embedded chart, activate the chart sheet and then
choose Chart➪Tools➪Design➪Location➪Move Chart to display the Move Chart dialog box.
Select the Object In option and specify the sheet by using the drop-down control.
Copying a Chart
To make an exact copy of a chart, select the chart (an embedded chart or a chart sheet)
and choose Home➪Clipboard➪Copy (or press Ctrl+C). Then activate a cell near the desired
location and choose Home➪Clipboard➪Paste (or press Ctrl+V). The new location can be in
a different worksheet or even in a different workbook. If you paste the chart to a different
workbook, it will be linked to the data in the original workbook.
Another way to copy a chart is to press Ctrl while dragging an embedded chart (or while
dragging a chart sheet’s tab).
Chapter 1: Introducing Excel Charts
Part I
27
05_044001 ch01.qxp 8/24/07 8:48 PM Page 27