Hello all,
The code blow works for excel 2016, but for excel 2007 the color comands gives the wrong colors. How should I write this code in excel 2007?
Cheers Raffe
Dim R
Dim G
Dim B
R = 127
R = 127
R = 127
ActiveChart.SeriesCollection(i).Name = "Test"
ActiveChart.SeriesCollection(i).Format.Line.ForeColor.RGB = RGB(R, G, B)
ActiveChart.SeriesCollection(i).Format.Line.Style = msoLineSingle
ActiveChart.SeriesCollection(i).Format.Line.DashStyle = xlContinuous
ActiveChart.SeriesCollection(i).Format.Line.Weight = 2
ActiveChart.SeriesCollection(i).MarkerBackgroundColor = RGB(R, G, B)
ActiveChart.SeriesCollection(i).MarkerForegroundColor = RGB(R, G, B)
ActiveChart.SeriesCollection(i).MarkerSize = 4
Bookmarks