Microsoft KB Archive/86198

{|
 * width="100%"|

Excel: Legend May Display Incorrectly on 3-D Surface Chart

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, version 4.0
 * Microsoft Excel for the Macintosh, version 4.0

-

SUMMARY
The legend on a 3-D Surface Chart will not display the correct information if the vertical axis has been reversed.

MORE INFORMATION
Unlike other charts in Excel, the legend on a 3-D surface chart does not refer to data series but to a value range.

Steps to Reproduce Problem

 * 1) Create a 3-D Surface Chart.
 * 2) From the Chart menu, choose Add Legend.
 * 3) Select the vertical axis.
 * 4) From the Format menu, choose Scale.
 * 5) Select the check box &quot;Values in Reverse Order&quot; and choose the OK button.
 * 6) The legend will now display improperly.

STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in a later version of Microsoft Excel.