Series Colored Differently - by groups

[Atanasi]

Hello All,

I have several series (lets say 10: Series1, Series2, ....Series10) and I just want make them in two groups colored differently. For example Series from 1 to 5 to be colored in RED and Series from 6 to 10 to be colored in BLACK.
I use "Scatter with smooth lines" for the graph.
I used a macro code (you can see it below), but it gave a option only to change to color of all series by changing RGB value.

Any help will be appreciated.
Best regards

Please Login or Register  to view this content.

[6StringJazzer]

For example Series from 1 to 5 to be colored in RED and Series from 6 to 10 to be colored in BLACK.

I would try this. For more detailed answers that have been tested please attach file.

Please Login or Register  to view this content.

[Atanasi]

Thank you very much for the answer, but some error appeared. Error.JPG
--> With .SeriesCollection(i).Fromat.Line
Do you have any idea what have to be do?

[Atanasi]

Yep it works. Thank you very much

[6StringJazzer]

You can copy and paste code from posts to avoid typing errors.