Does any one know the syntax for changing the color of a Line chart in Notes?I used the following syntax to change the color of a Bar chart.
xlSeries.Interior.ColorIndex = “18”
If any one knows it, please help me.
Thanks
Does any one know the syntax for changing the color of a Line chart in Notes?I used the following syntax to change the color of a Bar chart.
xlSeries.Interior.ColorIndex = “18”
If any one knows it, please help me.
Thanks
Subject: Changing the color of a line chart
By recording an Excel Macro I got the following:
ActiveChart.SeriesCollection(1).Select
With Selection.Border
.ColorIndex = 3
.Weight = xlThin
.LineStyle = xlContinuous
End With