ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to prevent trend line info in legend? (https://www.excelbanter.com/charts-charting-excel/206754-how-prevent-trend-line-info-legend.html)

Don Culp

How to prevent trend line info in legend?
 
For an XY (scatter) chart, if I add a trend line then the trend line
information is automatically added to the legend. Is there any way to
prevent this?

Excel 2003

Thanks,
Don Culp



ShaneDevenshire

How to prevent trend line info in legend?
 
Hi,

To the best of my knowledge you can prevent it from being added, but you can
remove it once it has been added.

Click the Legend once, then click the Trendline entry in the legend once and
press Delete.

I suppose you could code the removal of the trend line to make it automatic,
but that seem like overkill to me.

--
Thanks,
Shane Devenshire


"Don Culp" wrote:

For an XY (scatter) chart, if I add a trend line then the trend line
information is automatically added to the legend. Is there any way to
prevent this?

Excel 2003

Thanks,
Don Culp





All times are GMT +1. The time now is 02:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com