Microsoft KB Archive/220147

= XL97: Data Label Legend Keys Appear in Unexpected Locations =

PSS ID Number: 220147

Article Last Modified on 10/21/2000

-

The information in this article applies to:


 * Microsoft Excel 97 for Windows

-



This article was previously published under Q220147





SYMPTOMS
Extra data label legend keys may appear in unexpected or undesirable positions on a chart.



CAUSE
The problem may occur if all of the following conditions are true:


 * The chart was created from data containing 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.



WORKAROUND
To work around this problem, delete the misplaced data label markers. To do this, follow these steps:
 * 1) Click a data label one time to select it. Click the data label one more time. The data label should have a box around it to indicate that it is individually selected rather than an entire series.
 * 2) Press the DELETE key.
 * 3) Repeat steps 1 and 2 until all misplaced data markers have been deleted.



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



Chart Type Differences
If the conditions listed in the Cause section are true, the problem will be displayed differently depending on the chart type:

Stacked Column Chart
Some extra key/labels for blank cells may show at the top and/or bottom of the stacked columns even though empty cells are set to not be plotted.

Cluster Column type (not stacked)
Extra keys will appear stacked on top of each other in the upper left area of the chart outside of the plot area.

General Notes
If markers are moved manually, they may appear in different positions after you change the chart type from a stacked column chart to a two-dimensional unstacked column chart and vice versa.

In addition to the blank cells in the first column, blank cells in the second and subsequent columns of the source data will be added to the number of key markers shown. If the blank data cells are initially only in the second and subsequent data columns when creating the chart, the problem may not occur. Considering this, placing data in the blank cells of the first column may resolve the problem after the chart has been created.

Three-dimensional (3-D) charts do not exhibit the behavior described in this article.

Additional query words: XL97

Keywords: kbbug kbchart KB220147

Technology: kbExcel97Search kbExcelSearch kbExcelWinSearch kbZNotKeyword3

-

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

© 2004 Microsoft Corporation. All rights reserved.