DOCUMENT:Q98708 21-MAR-2001 [powerpt] TITLE :Linked Microsoft Excel Graphs Resized in PowerPoint PRODUCT :Microsoft PowerPoint for Windows PROD/VER:WINDOWS:3.0,4.0,4.0a,4.0c,5.0,7.0 OPER/SYS: KEYWORDS:kbinterop kbole ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - Microsoft PowerPoint for Windows, versions 3.0, 4.0 - Microsoft PowerPoint for Windows 95, version 7.0 - Microsoft Excel for Windows 95, versions 4.0, 4.0a, 4.0c, 5.0, 7.0 ------------------------------------------------------------------------------- SYMPTOMS ======== When a Microsoft Excel chart is linked to a Microsoft PowerPoint slide, the image of the chart changes size depending on the size of the chart window in Microsoft Excel at that time. CAUSE ===== Microsoft Excel provides the chart image linked to PowerPoint. The link is automatic by default. The chart window in Microsoft Excel dictates the size of the chart image in PowerPoint. WORKAROUND ========== Use the following steps to the change the automatic link to a manual one: 1. Create a chart in Microsoft Excel. 2. With the chart window unmaximized, select the Microsoft Excel chart. 3. On the Edit menu, click Copy. 4. Switch to PowerPoint. 5. On the Edit menu in PowerPoint, click Paste Special, and then click Microsoft Excel Chart Object. Click Paste Link. Note the size of the chart in PowerPoint. 6. Switch to Microsoft Excel and change the size of the window containing the chart. 7. Switch back to PowerPoint and note the change. To prevent Microsoft Excel from automatically resizing the chart, perform the following additional steps: 1. In PowerPoint, select the Excel Chart object, and then click Links on the Edit menu. 2. In the Edit Links dialog box, select the Manual option. The size of the chart in PowerPoint is determined by its size in Microsoft Excel. If the chart is maximized, it does not have specific dimensions to assign to PowerPoint. By setting the links to be updated manually, your charts will not be constantly changing size while you use and store your Microsoft Excel files. To avoid unwanted size changes, do not update the links while the Microsoft Excel chart is maximized or after the chart has been saved in a maximized position. Additional query words: 4.00 4 reduce resize Automatically ====================================================================== Keywords : kbinterop kbole Technology : kbExcelSearch kbPowerPtSearch kbExcel700 kbPowerPt700 kbZNotKeyword2 kbExcel95Search kbPowerPt700Search kbPowerPt400 kbPowerPt300 Version : WINDOWS:3.0,4.0,4.0a,4.0c,5.0,7.0 Hardware : x86 Issue type : kbprb ============================================================================= THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Copyright Microsoft Corporation 2001.