XL: Chart Trendline Equation or Data Label Disappears

ID: Q110499


The information in this article applies to:


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

Additional query words:


Keywords          : 
Version           : 5.00 5.00c 7.00
Platform          : WINDOWS 
Issue type        : 

Last Reviewed: July 29, 1999