Microsoft KB Archive/200816

From BetaArchive Wiki
Knowledge Base


XL97: 3-D Surface Chart Lines May Not Follow Slope of Data

Article ID: 200816

Article Last Modified on 10/21/2000



APPLIES TO

  • Microsoft Excel 97 Standard Edition



This article was previously published under Q200816


SYMPTOMS

When you create a 3-D surface chart, it may have unexpected peaks or valleys and may not be as smooth as expected.

CAUSE

This problem may occur when any of the following conditions are true:

  • The data is not part of a regular sequential series.


-or-

  • The data is not derived from mathematical formulas.


-or-

  • The major unit on the scale is different from the increments in the data.


STATUS

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

MORE INFORMATION

The points and plot of each data point on the grid seem to be correct, but the way they are connected between points create patterns that are often not as smooth as expected. This is most often observable when the chart is a surface type with a contour sub-type.


Additional query words: XL97 3D

Keywords: kbbug kbpending KB200816