Yes, yet another thread on Excel 2007/VS 2008/VSTO. I simply cannot change the line color on my charts. The below changes all work except the forecolor and backcolor properties. It loops through the series collection, setting the series line properties. What am I doing wrong??
Code:
MySeriesColl = MyChart.SeriesCollection 'required or else second series overwrites first one?
        For Each MySeries As Excel.Series In MySeriesColl
            MySeries.Format.Line.DashStyle = Microsoft.Office.Core.MsoLineDashStyle.msoLineSolid
            MySeries.Format.Line.Weight = "1"
            MySeries.Format.Line.Style = Microsoft.Office.Core.MsoLineStyle.msoLineSingle
            MySeries.Format.Line.ForeColor.RGB = Drawing.Color.Black.ToArgb
            MySeries.Format.Line.BackColor.RGB = Drawing.Color.Black.ToArgb
        Next
P.S. Should these threads be moved to the .NET forum? Or keep them here...