Microsoft KB Archive/78394

{| = Excel: PostScript Driver Sizes Chart Text Incorrectly =
 * width="100%"|

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.