Incorrect Line Extensions in X-Y Scatter Charts

 Last reviewed: November 3, 1994
Article ID: Q71927
The information in this article applies to:
  • Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 5.0
  • Microsoft Excel for OS/2, versions 2.2, 3.0

SUMMARY

When using the #2 scatter chart in Microsoft Excel, lines extending from the last data point to the edge of the chart may not display correctly.

MORE INFORMATION

Steps to Reproduce Problem

  1. Type the following into a worksheet: 

          A1: 10          B1: 10
      A2: 100         B2: 100
      A3: 1000        B3: 1000
      A4: 10000       B4: 10000

  2. Select cells A1:B4.

  3. From the File menu, choose New and then Chart. In Excel 3.0, select "X-Values for X-Y Chart". In all versions, choose Scatter from the Gallery menu and select Number 2.

  4. Change the scale on each axis, setting the maximum to 1500:

    a. Select the X-axis. b. From the Format menu, choose Scale. c. Type 1500 in the Maximum box. Choose OK. d. Follow the same steps for the Y-axis.

Depending on the height and width of the chart window, the last segment of the line (extending from the last data point) may not be in alignment with the rest of the line. This behavior may occur even though the graph should be a straight diagonal through the chart because the data is of the form x=y.

Microsoft is researching this problem and will post new information here as it becomes available.

Workaround

Size your chart window so that it is in the shape of a square, or as close as possible. This will give the appearance of a straight line. Before printing the chart, verify that Screen Size or Fit To Page is chosen under Page Setup from the File menu. Selecting Full Page may cause the printout to become distorted.

KBCategory: kbusage
KBSubcategory:

Additional reference words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0
3.00 4.0 4.00 5.0 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 3, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.