Microsoft KB Archive/177528

= XL97: Pie Chart Slices Don't Match Legend in Printout =

Article ID: 177528

Article Last Modified on 9/7/2001

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q177528



SYMPTOMS
When you print a pie chart or view it in print preview, the legend colors do not match the pie slice colors.



CAUSE
This behavior occurs when the following conditions are true:


 * You create a pie chart.

-and-
 * You click Page Setup on the File menu, click the Chart tab, and select the "Print in Black and White" check box.



RESOLUTION
To resolve this problem, format the pattern for each pie slice so that the area uses a specific color instead of the Automatic setting. Note that you can use the same pattern that is used for the Automatic setting. To set the area pattern for each pie slice, follow these steps:
 * 1) With the pie chart selected, click the pie once to select the entire data series.

This step selects the entire pie chart.
 * 1) Click a pie slice once to select that data point (pie slice).
 * 2) On the Format menu, click Selected Data Point.
 * 3) Click the Patterns tab. Under Area, click the color that is selected, and then click OK.
 * 4) Repeat steps 2 through 4 for all data points (pie slices).



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem no longer occurs in Microsoft Excel 2000.

Additional query words: XL97

Keywords: kbprint KB177528

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.