Excel: Data Point Label Appears Above the Top of a Chart

 Last reviewed: November 30, 1994
Article ID: Q83198
The information in this article applies to:
  • Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a, 5.0
  • Microsoft Excel for the Macintosh, versions 3.0, 4.0, 5.0

SYMPTOMS

A data point label may appear above the top of a chart if you have rescaled the y axis so the point the label is attached to is above the upper limit of the y axis scale. The label will appear in the title area of the chart as though the chart area continued beyond the end of the y axis.

WORKAROUND

Rescale the y axis so the data point the label is attached to is within the scale of the y axis. Alternatively, you can delete the label by selecting it and choosing Delete from the Edit Menu.

Steps to Reproduce Problem

  1. Enter the following into a worksheet: 

          A1:  1
      A2:  2
      A3:  4

  2. Select cells A1:A3 and choose New from the File menu. Select Chart and choose OK.

  3. Choose Attach Text from the Chart menu. Select Title and choose OK.

  4. Again, choose Attach Text from the Chart menu. Select Series and Data Point. Type 1 in the Series number box and 3 in the Point number box. Choose OK.

  5. Select the y axis and choose Scale from the Format menu. Change the Upper Limit from 4 to 3.5.

You will see the number 4 above the chart range to the right of Title.

STATUS

Microsoft has confirmed this to be a problem in the versions of Microsoft Excel listed above. We are researching this problem, and will post more information here in the Microsoft Knowledge Base as it becomes available.

KBCategory: kbusage
KBSubcategory:


Additional reference words: 5.00 4.00 3.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 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.