XL: Chart Trendline Equation or Data Label Disappears

 Last reviewed: September 13, 1996
Article ID: Q110499
The information in this article applies to:
  • Microsoft Excel for Windows, versions 5.0, 5.0c
  • Microsoft Excel for Windows NT, version 5.0
  • Microsoft Excel for Windows 95, version 7.0

SUMMARY

In Microsoft Excel, if you move a data label or a trendline equation on a chart, that label or equation may disappear when you change the data that the chart was created from.

CAUSE

When you move a data label or a trendline equation on a chart, the distance you move (offset) the label or equation is stored and is used when you change the data in the chart. You cannot detach a data label or trendline equation from a data point: the label or equation moves relative to the changing data. This relative movement may cause your data labels or trendline equations to move off of the chart area when you change the data you created your chart from.

WORKAROUNDS

To Restore a Data Label or Trendline Equation

To restore a data label or a trendline equation that has disappeared because your chart data changed, do the following:

  1. Select the plot area for the chart.

  2. Drag one of the corner handles on the selected plot area in to scale your chart to a smaller size.

  3. Select the label or equation that is located outside the plot area (that part that was previously hidden) and drag it back to the plot area.

  4. Select the chart plot area, and drag one of the corner handles on the selected plot area to scale the chart back to the original size.

To Restore a Trendline Equation Only

To restore a trendline equation that has disappeared because of changing chart data, you can use the above workaround, or you can remove the trendline equation and add it back as follows:

  1. Select the trendline on your chart.

  2. From the Format menu, choose Selected Trendline.

  3. Select the Options tab, and clear the Display Equation On Chart check box. Choose OK.

  4. From the Format menu, choose Selected Trendline.

  5. Select the Options tab, and select the Display Equation On Chart check box. Choose OK.

REFERENCES

For an Overview Of Adding A Trendline To A Data Series, choose the Search button in Help and type: 

    trendlines
For more information about Adding Data Labels, Changing Data Labels, or Creating Data Labels, choose the Search button in Help and type: 

    labels, data

KBCategory: kbusage
KBSubcategory:

Additional reference words: 7.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: September 13, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.