XL2000: Data Label Legend Keys May Appear in Unexpected Positions

ID: Q215854

The information in this article applies to:

Microsoft Excel 2000

SYMPTOMS

Extra data label legend keys may appear in unexpected or unwanted positions on a chart or PivotChart

CAUSE

This problem may occur if the following conditions are true:

You created the chart from data with some blank cells in the first column.

-and-
The chart type is a two-dimensional column chart.

-and-
Values or labels are shown with a legend key next to the label.

-and-
The chart is set to not plot empty cells. (To set this option, click Options on the Tools menu, and click the Chart tab.)

WORKAROUND

To work around this problem, delete the misplaced data label markers. To do this, follow these steps:

Single-click the individual data label twice to select it. The label should have a box around it to indicate that it is individually selected, rather than as a series.

Press DELETE.

Repeat steps 1 and 2 until all misplaced data markers have been deleted.

STATUS

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

MORE INFORMATION

Chart Type Differences

When the conditions listed in the "Cause" section are true, the following chart types will display this problem in different ways.

Stacked Column Chart
Some extra key/labels for blank cells may appear at the top and/or bottom of the stacked columns, even though empty cells are set to not be plotted.
Clustered Column Type (Not Stacked)
The extra key(s) appear stacked on top of each other in the upper-left portion of the chart, outside of the plot area.
PivotChart - Cluster Column Chart
The extra key(s) appear stacked on top of each other, on the left of the Drop Page Fields Here area.

General Notes

If you move markers manually, they may appear in different positions when you switch the chart between a stacked column chart and a two-dimensional unstacked column chart.

Although some blank data in the second and later columns will add to the number of key markers shown, if the blank data cells are initially only in the second and later columns, the problem does not seem to occur. Putting data in the blank cells in the first column may resolve the problem after you create the chart.

3-D charts do not have the problem described in this article.

Additional query words: XL2000 location

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