Microsoft KB Archive/214343

= XL2000: Category Axis Labels May Appear Twice in Chart =

Article ID: 214343

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q214343





SYMPTOMS
In Microsoft Excel 2000, two sets of labels may appear below the category axis in a chart.



CAUSE
This behavior can occur when the following conditions are true:  You create a chart that contains two value axes and at least two series.

-and- You rotate the labels on the secondary value axis to between 1 and 89 degrees. To do this, follow these steps:  Select the secondary value axis. On the Format menu, click Selected Axis, and then click the Alignment tab. Set the alignment to a value from 1 to 89, inclusive, and then click OK.

-and-

</li> You add a data table to the chart. To do this, follow these steps:  On the Chart menu, click Chart Options, and then click the Data Table tab.</li> Click to select the Show Data Table check box, and then click OK.</li></ol> </li></ul>

To see an example of this behavior, see the "More Information" section.

In some cases, this behavior occurs only if you change the font used by the category axis in any way. For example, you change the font or font size.

NOTE: This behavior does not occur if you rotate the labels on the primary value axis or if you rotate the labels on the secondary value axis to 90 or 0 (zero) degrees or to any negative number.

<div class="workaround_section">

WORKAROUND
To work around this problem, remove one of the sets of labels by following these steps:


 * 1) Select the category axis.
 * 2) On the Format menu, click Selected Axis, and then click the Font tab.
 * 3) In the Color list, select the color that is the same as the background color of the chart. (Usually, this color is white). In the Background list, click Transparent.
 * 4) Click OK.

The duplicate set of labels disappears; although the set is still there, it is formatted so that it does not appear on the screen.

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in Excel 2000.

<div class="moreinformation_section">

Example
To see an example of this problem, follow these steps:   Create a new workbook. Type the following values in Sheet1: <pre class="fixed_text">  A1:        B1: 1st Qtr   C1: 2nd Qtr   D1: 3rd Qtr   E1: 4th Qtr A2: East  B2: 20        C2: 30        D2: 90        E2: 20 A3: West  B3: 30        C3: 40        D3: 35        D3: 30 </li> Select cells A1:D3, and then click the Chart Wizard tool on the Standard toolbar. In the list of chart types, select Column. Then, click Finish.

A new chart appears in the worksheet.</li> Select the category axis. Use the Font Size tool on the Formatting toolbar to increase the font size of the axis labels by one or two points.</li> Select the second series (West) in the chart. On the Format menu, click Selected Data Series.</li> Click the Axis tab. Click Secondary Axis, and then click OK.</li> On the Chart menu, click Chart Options, and then click the Data Table tab.</li> Click to select the Show Data Table check box, and then click OK.

The data table appears below the chart.</li> Select the secondary value axis on the right side of the chart.</li> On the Format menu, click Selected Axis. Click the Alignment tab. Set the alignment to between 1 and 89 degrees, and then click OK. Note that two sets of labels appear below the category axis: one set for the axis itself, and one set for the data table.

If you use the steps in the "Workaround" section, the second set of labels disappears.</li></ol>

Keywords: kbbug kbpending KB214343

-

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

© Microsoft Corporation. All rights reserved.