Microsoft KB Archive/115393

= Microsoft Knowledge Base =

XL: Axis Text Shows Through Data Label
Last reviewed: March 27, 1997

Article ID: Q115393

5.00 5.00c 7.00 7.00a | 5.00 5.00a WINDOWS | MACINTOSH kbusage

The information in this article applies to:


 * Microsoft Excel for Windows 95, versions 7.0, 7.0a
 * Microsoft Excel for Windows, versions 5.0, 5.0c
 * Microsoft Excel for the Macintosh, versions 5.0, 5.0a

SYMPTOMS
In Microsoft Excel, when you place a chart data label on top of one of the chart axes, the chart axis text, such as a tick mark label, or the axis title, shows through the data label; however, the chart axis itself does not show through the data label.

CAUSE
This behavior occurs when you format a chart data label with a solid pattern, and you move the chart data label to one of the chart axes so that the label is on top of the chart axis text. The chart axis text shows through the data label, even though the data label has a solid pattern, and the chart axis itself does not show through.

Note that if you move a chart data label on top of the chart title, the title does not show through a chart data label.

Also, if you move a data label on top of a text box on a chart, the text in the text box shows through the data label. However, if the text box is formatted with a solid pattern, the text box covers the data label.

WORKAROUND
To avoid this behavior when you move a label over the chart axis, insert the label as a text box on the chart. Chart axis text does not show through a text box label on a chart.

STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.