Chart Trendlines, Adding/Removing & Formatting

[nigelk]

Hi All,

I have some charts on a worksheet, and I can add a trendline with

ChartObjects(1).Chart.SeriesCollection(1) _
    .Trendlines.Add Type:=xlLinear, Name:="Linear Trend"

I've got two questions

1. is it possible to toggle then trendline on/off
2. How do you format it? I would like a 'dash type, round dot',

but when I record a macro, nothing shows? (Using Excel 2007)

Can you help?