Microsoft KB Archive/45082

Numbers on Chart Axis Are Not Printed in Excel PSS ID Number: Q45082 Article last modified on 02-26-1993 PSS database name: W_eXceL

2.x 3.00

WINDOWS

Summary:

When using Microsoft Excel charts, the numbers on the axis may not appear on the printout and the letters may show up in Print Preview as boxes.

This behavior can be caused by changing the colors in the Microsoft Windows environment. The default colors in an Excel chart are based on the current colors in the Windows environment.

There are two workarounds for this behavior, as follows:


 * 1) Reformat the colors on the chart by selecting the axis, choosing Format Font, and changing the foreground color to black and the background to automatic or invisible. In Excel 3.0, choose Format Patterns instead to change the foreground and background colors.
 * 2) Delete all entries in the Colors section of the WIN.INI file. If using Windows 3.0 or 3.1, try using the default colors.

Note that the reverse of this behavior may also occur; axis text will print correctly, but the chart will not. The above workarounds are also valid in this case.

Copyright Microsoft Corporation 1993.