XL2000: Text Is Truncated in Text Box on Chart in Worksheet When Printed or Previewed

ID: Q214332


The information in this article applies to:
  • Microsoft Excel 2000


SYMPTOMS

When you print or preview a chart using print preview, text contained in a text box on your chart may be truncated even though it appears correctly on the worksheet.


CAUSE

This problem occurs because the text box doesn't automatically resize itself to display all the text in it. Note that this problem does not occur if you print or preview a chart on a chart sheet.

NOTE: This may particularly occur if you make changes to the size of the text box before attempting to print, or if you use the steps in the "Resolution" section of this article, and then change back to the default setting (Do not size with chart).


RESOLUTION

To have all of the text within the text box appear when you print or preview the chart on a worksheet, perform the following steps for each text box in the chart:

  1. Select the text box by clicking its border.

    If the blinking cursor appears in the text box, press ESC once.


  2. On the Format menu, click Selected Object. Click the Properties tab.


  3. Click Size with chart and click OK.



STATUS

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

Additional query words: cut off cutoff truncated clipped XL2000

Keywords : kbprint xlformat xlchart xlprint
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug


Last Reviewed: May 28, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.