How to prevent trend line info in legend?

D

Don Culp

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
 
S

ShaneDevenshire

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moving average trend line 1
Trend line with negatives Excel 2007 0
Trend Lines and the Legend 6
x-y scatter plots and trend lines 0
Trend lines in charts under Excel 1
Non Linear Scatter plot, need to find y value 3
Trend line equation 2
How to provide global admin but restrict access to user's mails 0

Top