Microsoft KB Archive/150686

= XL97: Moving Text Box on Chart Causes Chart to Grow =

Article ID: 150686

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Word 97 Standard Edition

-



This article was previously published under Q150686





SYMPTOMS
When you move a text box that is located in a Microsoft Excel chart, you may experience one or more of the following problems:


 * The text box grows larger.
 * The chart grows much larger.
 * The chart that you have pasted into your Microsoft Word document grows much larger.



CAUSE
These problems can occur if the following conditions are true:


 * You create a chart in Excel.

-and-
 * You add a text box to the chart.

-and-
 * You zoom the Excel worksheet to a percentage other than 100%.

-and-
 * You copy the chart.

-and-
 * You click Paste Link in the Paste Special dialog box in Word.



STATUS
Microsoft has confirmed this to be a problem in the products listed at the beginning of this article.



WORKAROUND
To work around the problem, set the zoom level of the worksheet that contains the chart to 100%.



Example of the Problem
The following steps illustrate how to reproduce the problem:

 Start Excel 97. Type the following values into a new workbook:

A1: 1 A2: 2

 Select cells A1:A2, and then click Chart on the Insert menu. Click Finish in the Chart Wizard dialog box.

A column chart is created on Sheet1. If the Drawing toolbar is not already visible, click the Drawing button on the Standard toolbar. Draw a text box on the chart.</li> Type some text in the text box.</li> Click a cell on the worksheet to activate the worksheet.</li> Click Zoom on the View menu. Click 75%, and then click OK.</li> Click the chart, and then click Copy on the Edit menu.</li> Start Word 97.</li> Click Paste Special on the Edit menu. Click Paste Link, and then click OK.</li> Activate Excel.</li> Move the text box around on the chart.</li></ol>

The chart may zoom or resize itself. If you activate Word, you will see that the chart has been resized.

Keywords: kbbug kbchart kbfix kbinterop kbqfe KB150686

-

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

© Microsoft Corporation. All rights reserved.