Microsoft Office Tutorials and References
In Depth Information
Working with Charts
To move an embedded chart, just click its border at any location except one of the eight resizing
handles. Then drag the chart to its new location. You also can use standard cut-and-paste techniques
to move an embedded chart. Select the chart and choose Home Clipboard Cut (or press Ctrl+X).
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
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 prefer that your chart be located on a chart sheet, you can easily 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 5-16. Select
the New Sheet option and (optionally) provide a different name for the chart sheet.
Figure 5-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 command.
Copying a chart
To make an exact copy of an embedded chart, select the chart 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.
To copy a chart on a chart sheet, press Ctrl while you click and drag the sheet tab to the left or right.
After you let go of the mouse, you will have a copy of the chart sheet.
Search JabSto ::




Custom Search