Set the color of the chart object

  • I want to set the color of the line.

    With Sheets("Graph").ChartObjects("Chart 3")
            .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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!