Adding a trendline in Excel.

Hi there,

I can write the script in VBA to add a trend line to a selected series collection, but I have not a clue how to do it in VB.Net.

I have trawlled the web for numerous hours and hours and cannot seem to find how to add a trendline in my chart.

Also i cannot seem to change the colour of one of my series collections(I hate the yellow) and excel does yellow as the 3rd series by default.

So:
1. How do i add a trend line command in VB.Net ?
2. How do i change the colour of the points in VB.Net ?

Thank you so much for your help.

Ken