Excel: PostScript Driver Sizes Chart Text Incorrectly

 Last reviewed: November 1, 1994
Article ID: Q78394

SUMMARY

PostScript printer drivers provide the option to reduce or enlarge a Microsoft Excel chart by a certain percentage if the size chosen under Page Setup is Screen Size. If Fit To Page or Full Page is selected as the size, the Reduce Or Enlarge percentage should be ignored; however, any text that exists in the chart is scaled even though it should not be.

MORE INFORMATION

To reduce or enlarge a chart, choose Page Setup from the File menu and select Screen Size. If Screen Size has been selected and the Reduce Or Enlarge percentage is changed to something other than 100, the chart prints according to the selected percentage. If the Fit To Page or Full Page option is then selected, Reduce Or Enlarge is no longer a selectable option. However, any chart text reads the previously selected percentage, and scales the text to that percentage.

Workaround

  1. From the File menu, choose Page Setup.

  2. Select Screen Size as the Size option and change the percentage to 100%.

  3. Reselect your original Size option and choose the OK button to close the dialog box.

Steps to Reproduce Problem

  1. Verify that you are using a Windows PostScript driver by choosing Printer Setup from the File menu.

  2. Create a chart and include a title on the chart.

  3. Select the title in the chart. Choose Font from the Format menu and select TMS RMN 24. Choose the OK button.

  4. From the File menu, choose Print Preview. Note the size of the title on the preview screen.

  5. From the Print Preview dialog box, choose the Setup button. The Fit To Page option should be currently selected under Size, and Reduce Or Enlarge should be unavailable (dimmed).

  6. Select Screen Size under Size to make the Reduce Or Enlarge option available (not dimmed). Enter 50 into the percentage box (following Reduce Or Enlarge).

  7. Select Fit To Page. Notice that the Reduce Or Enlarge option is unavailable (dimmed) again, although the 50 is still visible in the percentage box.

  8. Choose OK to close the Setup dialog.

Notice that the title in the chart has been significantly reduced even though the rest of the chart remains the same size.

Microsoft is researching this problem and will post new information here as it becomes available.

REFERENCES

"Microsoft Excel User's Guide," version 3.0, pages 498, 531

Additional reference words: 3.00



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.

Last reviewed: November 1, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.