Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

XL2000: PivotChart Button Overlaps Data Labels in Pie Chart


View products that this article applies to.

This article was previously published under Q210794

↑ Back to the top


Symptoms

If you create a PivotChart as a pie chart with labels, some labels may be hidden by a pivot button.

↑ Back to the top


Cause

This problem may occur if there are many slices in the pie and the smaller slices are located at the end of the PivotTable data.

When you add labels to a pie chart, by default, Excel places the labels outside the chart, which may place them under a pivot button on a PivotChart.

↑ Back to the top


Workaround

To work around this problem, use any of the following methods.

Method 1: Hide the PivotChart Field Buttons

To hide the PivotChart field buttons, click the PivotChart drop-down arrow on the PivotTable toolbar and click Hide PivotChart Field Buttons.

Method 2: Adjust the Position of the Data Labels

Adjust the position of the data labels to be inside or centered, instead of outside. To do this, follow these steps:
  1. Right-click a data label, and click Format Data Labels on the shortcut menu.
  2. On the Alignment tab, click the Label Position drop down arrow, and click Inside End or Center.

Method 3: Rotate the Pie Chart

Rotate the pie chart so that the labels are not under the button. To do this, follow these steps:
  1. Click to select the pie chart, and then click Format Data Series on the Format menu.
  2. On the Options tab, adjust the Angle of first slice box until a larger slice is in the position next to the button.

Method 4: Move the Obscured Labels

Individually move the obscured labels further away from the pie. To do this, click a label twice so that it has a box around it and is individually selected. Then, click the edge of the box and drag it away from the edge of the pie. By default, the Show leader lines check box is selected on the Data Labels tab of the Format Data Series dialog box, which results in the display of the leader lines connecting the label to the slice.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top


References

For more information about PivotCharts, click Microsoft Excel Help on the Help menu, type PivotCharts in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

↑ Back to the top


Keywords: KB210794, kbpending, kbbug

↑ Back to the top

Article Info
Article ID : 210794
Revision : 3
Created on : 9/25/2003
Published on : 9/25/2003
Exists online : False
Views : 263