XL97: Pie Chart Slices Don't Match Legend in Printout (177528)



The information in this article applies to:

  • Microsoft Excel 97 for Windows

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.
  2. Click a pie slice once to select that data point (pie slice).
  3. On the Format menu, click Selected Data Point.
  4. Click the Patterns tab. Under Area, click the color that is selected, and then click OK.
  5. 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.

Modification Type:MajorLast Reviewed:9/7/2001
Keywords:kbprint KB177528