Microsoft KB Archive/72863

{| = Minimum X-Axis Value Defaults to Zero in Excel =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q72863

SUMMARY
Microsoft Excel 3.0 calculates the minimum value for the X-axis on a scatter chart differently than it does in earlier versions. If you create a scatter chart using a small amount of data, Excel 3.0 will display a minimum X-axis value that is close to the minimum X value in the data. Using a large amount of data, Excel will display a minimum X-axis value of zero.

MORE INFORMATION
The point at which Excel 3.0 reverts from a minimum value of zero to a minimum value close to the minimum X value is dependent upon the range of X values and the number of values plotted.

Steps to Reproduce Problem
 Type =RAND*25+50 in cell A1. Select cells A1:A20 and choose Fill Down from the Edit menu. With the area still selected, choose Copy from the Edit menu. Then choose Paste Special from the Edit menu, select Values and choose OK. This replaces the formulas with values. Use Data Sort to sort the values. Enter random values in cells B1:B20. Select cells A1:B20 and press F11 to create a new chart.  Select First Column Contains X-Values for XY-Chart. Note that the minimum value on the X-axis is zero.  Create a new, similar chart using cells A1:A10.</li></ol>

Note that the minimum value on the X-axis is close to the minimum X value. In Excel 2.x, both charts would have a minimum X-axis value that is close to the actual minimum X value.

Workaround
Use the Format Scale command and manually change the minimum X value for the X-axis.