Scatter Charts: Plot Line Beyond Specified Maximum Value

 Last reviewed: November 29, 1994
Article ID: Q69783
The information in this article applies to:
  • Microsoft Excel for Windows, versions 3.0, 4.0, 5.0

SYMPTOMS

In Microsoft Excel, when you set a maximum value for either the horizontal (x) or vertical (y) axis on an XY (scatter) chart, the plotted line extends beyond the maximum value by approximately 1/16 of an inch.

CAUSE

This behavior occurs when you specify a maximum value for either the horizontal or vertical axis, and the chart data extends beyond this value.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post more information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Microsoft Excel version 5.0

To set a maximum value for a data axis in Microsoft Excel version 5.0, do the following:

  1. Select the axis on the chart for which you want to set a maximum value.

  2. From the Format menu, choose Selected Axis.

  3. Select the Scale tab, and in the Maximum box, enter the maximum value you want for the axis. Clear the Auto check box for the Maximum option, and choose OK.

Microsoft Excel versions 3.0 and 4.0

To set a maximum value for a data axis in Microsoft Excel versions 3.0 and 4.0, do the following:

  1. Select the axis on the chart for which you want to set a maximum value.

  2. From the Format menu, choose Scale.

  3. In the Format Scale dialog box, in the Maximum box, enter the maximum value you want for the axis and choose OK.

If the value you enter in Step 3 is smaller than the largest data value for this axis, the plotted line extends beyond this maximum value by approximately 1/16th of an inch.

KBCategory: kbusage
KBSubcategory:

Additional reference words: 3.00 4.00 5.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 29, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.