Microsoft KB Archive/166862

= PPT97: Microsoft Excel Chart Cropped When Pasted in PowerPoint =

Article ID: 166862

Article Last Modified on 2/15/2002

-

APPLIES TO


 * Microsoft PowerPoint 97 Standard Edition
 * Microsoft Excel 97 Standard Edition
 * Microsoft Windows NT Workstation 3.51
 * Microsoft Windows NT Workstation 4.0 Developer Edition

-



This article was previously published under Q166862



SYMPTOMS
If you paste or paste link a Microsoft Excel 97 chart object from its own chart sheet into a PowerPoint 97 slide, the object is cropped and the legend may not appear. This symptom does not occur when you paste a Microsoft Excel 97 chart object that is embedded on a worksheet into a PowerPoint 97 slide. This behavior occurs when you are using the Microsoft Windows NT operating system; it does not occur when you are using Windows 95.



WORKAROUND
To work around this behavior use one of the following methods.

Method 1: Reduce Chart Size Before Copying
To reduce the chart size before you copy it, follow these steps:
 * 1) In Microsoft Excel, click to select the white area around the edge of the Microsoft Excel chart.

The chart area should be selected.
 * 1) Drag a corner sizing handle toward the center of the object until the chart area is approximately 75 percent of its original size.
 * 2) Select the legend, if present. Move it closer to the plot area.
 * 3) Click anywhere in the worksheet to cancel the selection.

When you use the copy and paste operation, the entire chart pastes onto the PowerPoint slide.

Method 2: Change View Option in Excel
To change the view option in Excel, follow these steps:
 * 1) In the chart window, click Size with Window on the View menu.

This option controls whether the size of a chart sheet is dependent on, or independent of the window size. By default, a newly created chart sheet is independent of the window size.
 * 1) Use the copy and paste operation to paste the entire chart onto the PowerPoint slide.



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

Additional query words: winnt ppt97 ppt8.0 8.00 8.0 excel97 xl97 view window

Keywords: kbinterop kbchart kbprb KB166862

-

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

© Microsoft Corporation. All rights reserved.