Microsoft KB Archive/93254

From BetaArchive Wiki

Excel: Text Values in XY (Scatter) Chart Change Format

The information in this article applies to:

  • Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a, 5.0
  • Microsoft Excel for OS/2, version 3.0
  • Microsoft Excel for the Macintosh, versions 3.0, 4.0, 5.0


When you create an xy (scatter) chart in Microsoft Excel, the data for the x values should not contain text. If a cell in the x-value range of the chart contains text, Microsoft Excel uses the series {1,2,3...} instead of the values on the worksheet.

To correct this problem, remove the text from the x values.


This problem occurs because the x-value series is only valid when it contains numeric values. If text is included in the series, Microsoft Excel defaults the x series to a linear 1,2,3-type scale.


"Microsoft Excel User's Guide 1," version 4.0, pages 394-400

"Microsoft Excel User's Guide," version 3.0, pages 391-407

Additional query words: 3.0 line curve chart scatter

Keywords :
Version :
Platform :
Issue type :
Technology :

Last Reviewed: March 30, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.