XL2000: PivotChart Button Overlaps Data Labels in Pie Chart

ID: Q210794

The information in this article applies to:

Microsoft Excel 2000

SYMPTOMS

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

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.

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:

Right-click a data label, and click Format Data Labels on the shortcut menu.

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:

Click to select the pie chart, and then click Format Data Series on the Format menu.

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.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

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.

Additional query words:

Keywords :
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug