XL2000: Chart Object Truncated After Paste Linking into PowerPoint

ID: Q215324

The information in this article applies to:
  • Microsoft Excel 2000

SYMPTOMS

When you paste link a Microsoft Excel chart object into a Microsoft PowerPoint slide, the right portion of the chart object appears truncated. If the object has a border, the bottom and right borders are missing.


CAUSE

This problem occurs when you reduce the zoom percentage of the chart object to less than 100 percent before you copy it. The amount of the object that is truncated depends on the zoom percentage. When the zoom percentage is closer to 100 percent, you will see more (or all) of the object when pasting it. For example, at a 50 percent zoom level, you will see the legend in the pasted object. At a 25 percent zoom level, the right half of the object will be missing. Not only will the legend be missing, but some of the series columns may also be missing. In both cases, the right and bottom borders will be missing.


WORKAROUND

To work around this problem, use the appropriate method for your situation.

Copy and Paste the Object

To paste a fully rendered object, copy the object by using one of the following methods.
  • Paste the object rather than paste linking it.

    -or-

  • Copy the object at 100 percent zoom level.

    -or-

  • Select the sheet after copying the object but before pasting it.

Update the Object

If you already copied the object, you can update the object so that the chart area appears correctly by using one of the following methods. Note that you still may not see the bottom and right border of the object. If this is the case, you can remove the border from the object by selecting the object and clicking Selected Chart Area on the Format menu and then clicking None on the Patterns tab.

Method 1: Update the Object Without Changing the Chart

  1. Switch to Excel.


  2. Click anywhere on the worksheet.


  3. Switch to PowerPoint.


  4. On the Edit menu, click Links.


  5. Click Update Now.


  6. Click Close.


Method 2: Update the Object After Changing the Chart

  1. Switch to Excel.


  2. Make a small change to the chart. For example, change the chart title and then change it back to its original text. Or, change the title formatting.


  3. Switch to PowerPoint.


  4. On the Edit menu, click Links.


  5. Click Update Now.


  6. Click Close.




STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: XL2000

Keywords : kbole kbdta kbchart
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug


Last Reviewed: November 2, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.