Microsoft KB Archive/42215

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Difference between Scatter Charts and Line Charts



The information in this article applies to:


  • Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0



The following article explains the difference between line and scatter charts.

It is a common misconception that if you want to plot a line on a chart that you use a line chart, when in many cases, a scatter chart is the appropriate chart to use.

The main difference between a line chart and a scatter chart is that a line chart's x-axis is not scaled, i.e., it has a fixed interval between each category. For example, if you are trying to plot a line and have 1,2,10 as x values, the distance between 1 and 2 on a line chart is the same as the distance between 2 and 10. If you use a scatter chart with the same x values, the distance between 1 and 2 is one unit while the distance between 2 and 10 is eight units.

Additional query words:

Keywords :
Version :
Platform :
Issue type :
Technology :


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