Set the color of the chart object

Philosophaie · Sep 19th 2012

I want to set the color of the line.

Code

With Sheets("Graph").ChartObjects("Chart 3")
        .Activate
        .Chart.SeriesCollection(1).XValues = Sheets("Data").Range("D2:D" & Sheets("Data").Cells(Rows.Count, "D").End(xlUp).Row)
        .Chart.SeriesCollection(1).Values = Sheets("Data").Range("E2:E" & Sheets("Data").Cells(Rows.Count, "E").End(xlUp).Row)
        .Chart.SeriesCollection(1).(What do I put here to set the color of the line)
End With

LocalPeople · Sep 21st 2012

Re: Set the color of the chart object

This sets to red:

Code

.SeriesCollection(1).Format.Line.ForeColor.RGB = RGB(255, 0, 0)

Set the color of the chart object

Participate now!

Share