PPT97: Microsoft Excel Chart Cropped When Pasted in PowerPoint

ID: Q166862

The information in this article applies to:

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 this to be a problem in the Microsoft products listed at the beginning of this article.

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


Keywords          : kbinterop kbdta kbchart 
Version           : WINDOWS:97; winnt:3.51,4.0
Platform          : WINDOWS winnt 
Issue type        : kbprb

Last Reviewed: July 7, 1999