Unable to Delete Trendline in Excel 2003

**lengli02** · 11-09-2010, 10:47 AM

I'm sorry that this is an amateur question, but my trendline won't delete even after I Clear it or press Delete, and it won't allow me to choose None in the Trendline options. I searched for answers on every search engines, but I only found these two suggestions which aren't working. Has anyone had this happen before? Background on the chart... I did Copy another chart that had a trendline and used its formatting for this one, but now they don't want the trendline. Thanks in advance.

**Andy Pope** · 11-09-2010, 11:18 AM

You will have to post workbook in order for use to help.

If you can select the trend line then you should be able to delete it.

**lengli02** · 11-09-2010, 11:32 AM

I have recreated the chart using a copied version of the one I'm having trouble with. Hm, odd... when posting this one, I'm able to delete it. Perhaps the original chart's issue has to do with a protection option?

**Andy Pope** · 11-09-2010, 11:43 AM

Can you format the trend line in the bad file?

**lengli02** · 11-09-2010, 11:46 AM

I can do everything to the trend line format except get rid of it. I checked all other tabs with trend lines, and they're all able to be deleted; this one just happens to not want to.

**Andy Pope** · 11-09-2010, 11:48 AM

without seeing the actual problem chart it's impossible to say.

**lengli02** · 11-09-2010, 11:51 AM

Due to the material, I cannot. The best I could do is recreate it using the original, but if that version works, then I don't know. I suppose I'll have to get creative. Thank you anyway, I appreciate it.

**Mike_XVB** · 12-10-2010, 02:42 AM

Hi. I had the same problem, but after reading this page, an idea popped into my head that solved the problem. :D

I could see the legend for a tendline I made earlier, but couldn't see the actual line itself, therefore couldn't delete it manually. The idea/realisation that came to me was that: Some time after I added the trendline, I changed my chart type. The current chart (X-Y scatter) type didn't support the previous trendline type (logarithmic) which I used in the old chart type (line graph). So I changed back to line graph and hey presto, the actual line appeared for me to delete.

After that, I thought this macro might work...

Sub remove_trendline()
ActiveChart.SeriesCollection(1).Trendlines(1).Select
Selection.Delete
End Sub

Of course you may have to play with the number e.g. write Trendlines(2) or something. I hope one of these solutions works. P.S. I was using Excel 2003.