straight line connecting first and last point on a chart

[hermac]

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

 

[Tom Ogilvy]

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

 

[hermac]

Thanks Tom,

You helped me a lot. That's indeed all it took :

.SeriesCollection.NewSeries
.SeriesCollection(2).XValues = "={0,365}"
.SeriesCollection(2).Values = "={0," & S & "}"
where S is the last point's value.

Sometimes it is so simple that it is overlooked.