Microsoft KB Archive/173949

From BetaArchive Wiki
Knowledge Base

XL97: Objects in Chart May Not Appear in Sample Chart

Article ID: 173949

Article Last Modified on 10/21/2000


  • Microsoft Excel 97 Standard Edition

This article was previously published under Q173949


In Microsoft Excel 97, if you double-click a series in a chart in a worksheet, and then click the Options tab in the Format Data Series dialog box, the sample chart that appears in the dialog box may not display some or all of the drawing objects or AutoShapes in the chart.


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

  • The width or the height of the embedded chart is less than 200 pixels. -or-

  • The drawing objects or AutoShapes are located at the right edge or the bottom edge of the chart.


Even though the sample chart does not appear correctly in the Format Data Series dialog box, the drawing objects and AutoShapes appear in the chart and are printed correctly.

To resolve this problem, resize the chart so that its height or width is larger than 200 pixels or move the drawing objects and AutoShapes away from the right or bottom edge of the chart.


Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: XL97

Keywords: kbbug kbchart kbui kbgraphic KB173949