I've got a chart embedded in a spreadsheet that is called 'Chart 1'.
I've got some code to run and set the trendline which seems to run ok.
Dim STPChart As Chart
Set STPChart = Worksheets("Detector1_Report").ChartObjects("Chart 1").Chart
With STPChart
blah blah blah...
However, I don't...