PSS ID Number: Q141570
Article last modified on 01-03-1996
PSS database name: EXCEL
5.00 7.00 | 5.00
WINDOWS | MACINTOSH
--------------------------------------------------------------------
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
--------------------------------------------------------------------
SUMMARY
=======
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.
MORE INFORMATION
================
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
KBSubcategory:
Additional reference words: 5.00 7.00
=============================================================================
Copyright Microsoft Corporation 1996.