Microsoft KB Archive/211476

= XL2000: Copied and Pasted Chart Appears as Gray Rectangle =

Article ID: 211476

Article Last Modified on 10/7/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211476





SYMPTOMS
When you copy a chart in Microsoft Excel and paste it into a document in another program (for example, Microsoft Word or Microsoft WordPad), the chart you pasted appears as a gray rectangle.



CAUSE
This problem occurs when you select the Show placeholders option in Microsoft Excel before you copy the chart.



WORKAROUND
To work around this problem, use either of the following methods.

Method 1: Activate Microsoft Excel

 * 1) Double-click the pasted chart. This activates Microsoft Excel and displays the chart.
 * 2) When the chart appears correctly, click anywhere in the document to deactivate Microsoft Excel.

Method 2: Clear the Show Placeholders Check Box
If the Show placeholders option is enabled, follow these steps before you copy the chart:


 * 1) On the Tools menu, click Options.
 * 2) Click the View tab.
 * 3) Click Show all, and then click OK.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
In Microsoft Excel, you can control the appearance of objects in a worksheet. To access the options that allow you to control the appearance of objects, follow these steps:


 * 1) On the Tools menu, click Options.
 * 2) Click the View tab.

The following table lists the options and how they affect the appearance of objects in the worksheet.

 Option              Affect --

Show all            All objects are displayed normally.

Show placeholders   A gray object appears in the place of each object in                      the worksheet. Details for each object are not visible.

Hide all            All objects are not displayed.

If you select the Show placeholders option, all drawing objects, AutoShapes, and charts in the worksheet are displayed as gray objects. If you select a chart, the chart appears normally for as long as it remains selected; when you deselect the chart, it appears as a gray rectangle.

If you copy a chart in Microsoft Excel when the Show placeholders option is selected, and then paste the chart into another program, the chart may not be pasted correctly. This behavior may occur even when the chart appears correctly when you copy it. This problem may occur when you paste a chart in Microsoft Word or Microsoft WordPad.

Additional query words: grey rectangle XL2000

Keywords: kbbug kbchart kbualink97 kbpending KB211476

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.