Invisible trend line? How to delete?

[Charlie Howell]

I created a linear trend line on a chart, but the trend line is
invisible. To delete the trend line, it seems that I have no other
option but to click on the trend line to select, then delete. How do I
select a trend line that I cannot see?

Thanks, in advance, for any assistance.

[Jon Peltier]

Charlie -

In the Charting toolbar, there's a dropdown that lists the elements in
the chart. Scroll down until you can select the trendline listed, then
press the Delete key.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

[Charlie Howell]

Dude, Thanks! I knew there had to be a way . . .

[James Silverton]

"Jon Peltier" <jonpe...@yahoo.com> wrote in message
news:3EC657C6...@yahoo.com...

That's certainly the right way to do it but, if you are lazy or don't have
the charting toolbar visible, it's usually quite easy to pick out a
background colored trendline by looking for gaps in other lines on the
chart. A right click once the trendline box appears will send you in the
right direction. I'm speaking from sad experience when I accidentally picked
the wrong color for a trendline :-)

--
James V. Silverton
Potomac, Maryland, USA

[Jon Peltier]

James -

You could always change the color of the background, then, and find your
trendline. Fortunately the Format Trendline dialog does not permit
"None" for line type.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

[jp.l...@gmail.com]

Had the same problem today (Mar 2020). In MS Excel 2016:
1. Click to select the chart
2. Click <Chart Design> in header
3. Locate <Add Chart Element> in upper left corner
4. Select the dropdown
5. Select <Trendline> then <None>

It eliminates all trendlines, but is a failsafe.