Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,344
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set a Trend Line and Remove the Data Line FlexoC Charts and Charting in Excel 2 August 22nd 08 05:15 PM
Getting Trend Line Info from Chart Carrie_Loos via OfficeKB.com Charts and Charting in Excel 11 August 6th 08 04:56 PM
switch around info from legend to axis Sallie Charts and Charting in Excel 1 June 8th 06 02:59 AM
Legend Missing Info Debra Ann Charts and Charting in Excel 0 October 11th 05 03:23 PM
trend line does not appear JB Charts and Charting in Excel 1 January 26th 05 08:24 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"