Consulting | Excel Examples

Copying an Embedded Chart to a Chart Sheet

PSS ID Number: Q141570
Article last modified on 01-03-1996
PSS database name: EXCEL

5.00 7.00 | 5.00


The information in this article applies to:

- Microsoft Excel for Windows 95, version 7.0
- Microsoft Excel for Windows, version 5.0
- Microsoft Excel for the Macintosh, version 5.0


In Microsoft Excel, it is possible to copy an embedded chart to a separate
chart sheet. To do this, follow the steps in the "More Information" section
of this article.


To copy an embedded chart to a chart sheet

1. To add a blank chart sheet to the workbook, select any cell on the
worksheet, and click Copy on the Edit menu. On the Insert menu, click
Chart, and then click As New Sheet. Click the Finish button in
ChartWizard. A blank chart sheet is inserted in the workbook before
the active sheet.

2. To copy the chart, select the worksheet tab that contains the chart you
want to copy. Double-click the chart to activate it. Use the DOWN ARROW
on the keyboard to move through the elements of the chart until the Name
box (the box at the left end of the formula bar) displays the word
"Chart." On the Edit menu, click Copy.

3. To paste the copied chart to the blank chart sheet, select the blank
chart sheet tab (this requires two clicks, one to turn off the in-place
editing of the chart and another to select the chart sheet), and then
click Paste on the Edit menu.

You will now have a copy of the embedded chart on its own chart sheet.
There is no link between the two charts, so you can delete the embedded
chart. The new chart will be linked to the same data as the embedded chart.

KBCategory: kbusage kbhowto

Additional reference words: 5.00 7.00
Copyright Microsoft Corporation 1996.


Last modified: May 21, 1996