why not add a new series with the first and last points as the only members.

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
Hello,

I'm familiar with VBA, charts and trendlines but I'm looking for a way
to add a straight line to a xlXYScatter chart, connecting the first and
last points of a series. Just to visually compare it to a linear
trendline.
I'd be very grateful for any suggestion.
Thanks,
Herman