PPT97: Microsoft Excel Chart Cropped When Pasted in PowerPoint

Article translations Article translations
Article ID: 166862 - View products that this article applies to.
This article was previously published under Q166862
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

On This Page

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.
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 166862 - Last Review: October 24, 2013 - Revision: 2.0
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
Keywords: 
kbnosurvey kbarchive kbchart kbinterop kbprb KB166862

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com