XL: Chart Series May Not Be Printed in Black and White

Last reviewed: February 2, 1998
Article ID: Q110859

The information in this article applies to:
  • Microsoft Excel for Windows, versions 5.0, 5.0c
  • Microsoft Excel for Windows 95, versions 7.0, 7.0a
  • Microsoft Excel 97 for Windows
  • Microsoft Excel for the Macintosh, versions 5.0, 5.0a
  • Microsoft Excel 98 Macintosh Edition

SYMPTOMS

When you print a chart in Microsoft Excel the series in the chart may not be printed in black and white even if Print In Black And White is selected in the Page Setup dialog box.

CAUSE

This problem occurs when the color of a series has been set to anything other than Automatic.

WORKAROUND

To prevent a series from printing in color, do either of the following:

  • Change the color of the series back to Automatic. To do this, follow these steps:

        1. Select the series.
    

        2. On the Format menu, click Selected Data Series.
    

        3. Click the Patterns tab.
    

        4. In the Area section, click Automatic.
    

        5. Click OK to accept the change.
    

        -or-
    
  • Disable color printing on your printer (this is usually accomplished by changing a setting in the Printer Setup or Properties dialog box).

STATUS

This behavior is by design of Microsoft Excel.

MORE INFORMATION

The Print In Black And White option in the Page Setup dialog box causes a chart to print exclusively in black, white, and shades of gray for all chart series whose patterns use an Automatic setting. To select the Print In Black And White option for the active chart, follow these steps:

  1. On the File menu, click Page Setup.

  2. Select the Chart tab.

  3. Select (check) the Print In Black And White check box.

  4. Click OK to accept the change.

The chart will now print in black, white, and shades of gray.

However, if any series in the chart has been formatted so that its pattern color is not Automatic, that series will not conform to the Print In Black and White setting. The series will be printed in color if your printer is set to print in color.


Additional query words: 5.00 7.00 8.00 97 98 XL98 XL97 XL7 XL5 grayscale
dithering
Keywords : xlchart xlprint kbprint
Version : WINDOWS:5.0,5.0c,7.0,7.0a,97; MACINTOSH:5.098
Platform : MACINTOSH WINDOWS
Issue type : kbprb
Solution Type : kbworkaround


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: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.