Microsoft KB Archive/109110

Microsoft Knowledge Base

XL: Color Missing in Plot Area Formatted as Pie or Doughnut

Last reviewed: March 27, 1997
Article ID: Q109110

5.00 5.00c 7.00 | 5.00 5.00a

WINDOWS         | MACINTOSH

kbusage

The information in this article applies to:

• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for the Macintosh, versions 5.0, 5.0a
• Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

In Microsoft Excel, if a combination chart contains two or more series and some of the series are formatted as pie charts or doughnut charts, you may not be able to specify the color of the plot area.

WORKAROUND

To make the color of the plot area visible when you are using a combination chart that contains one or more series formatted as a pie or doughnut chart, you must first make the entire chart into a pie or doughnut chart. To do this to an existing chart, follow the steps below:

1. In the chart sheet, choose Chart Type from the Format menu.
2. Under Apply To, select the Entire Chart option. Select the Doughnut type from the table of chart types, and then choose OK.
3. Select the plot area of the chart.
4. From the Format menu, choose Selected Plot Area.
5. Under Area, select the desired color and pattern. Choose OK.

You can now format individual series in the desired format (area, column, pie, and so on), and the plot area color will remain visible.

Note that if you use a chart type that uses axes (area, column, line, and so on), your axes may appear in the wrong location in the chart. To correct this problem, do the following:

1. Select an axis and choose Selected Axis from the Format menu.
2. Select the Scale tab.
3. Depending on the selected axis and the configuration of your chart, you will need to select or clear the three check boxes at the bottom of the Scale tab.
4. Choose OK to accept the change.

MORE INFORMATION

This error only occurs if one or more (but not all) series have been formatted as pie or doughnut charts: combination charts that include series that are formatted as any combination of area, bar, column, line, radar, or xy (scatter) charts will appear correctly.

KBCategory: kbusage KBSubcategory: Additional reference words: 5.00 5.00a 5.00c 7.00 Keywords : kbusage Version : 5.00 5.00c 7.00 | 5.00 5.00a Platform : MACINTOSH WINDOWS 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: March 27, 1997 ©1997 Microsoft Corporation. All rights reserved. Legal Notices.