PPT97: Microsoft Excel Chart Cropped When Pasted in PowerPoint (166862)


The information in this article applies to:

  • Microsoft PowerPoint 97 for Windows
  • Microsoft Excel 97 for Windows
  • Microsoft Windows NT Workstation 3.51
  • Microsoft Windows NT Workstation 4.0
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.
  2. Drag a corner sizing handle toward the center of the object until the chart area is approximately 75 percent of its original size.
  3. Select the legend, if present. Move it closer to the plot area.
  4. 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.
  2. 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.
Modification Type:MajorLast Reviewed:2/15/2002
Keywords:kbchart kbinterop kbprb KB166862
©2002 Microsoft Corporation. All rights reserved.