How to format multiple chart sheets using vba in excel

Change the formatting of multiple charts at once when they're in chart sheets using vba

Sub FormatCharts()

Dim cht As Chart

For Each cht In Application.Charts

With cht.FullSeriesCollection(1).Format.Line
.ForeColor.ObjectThemeColor = msoThemeColorAccent5
.Weight = 1
.DashStyle = msoLineLongDash
End With

Next

End Sub

[degreerule]

Hi Karina I was excited to look at your channel on your expertise in Excel and I was wondering if you could help me with a combination sheet that has 9 groups consisting of 4 players in each group. In week two no one individual player should meet with the player that he played with in week one and so on and so on for 9 weeks. I have a sheet that I can provide to you. thanks in advance for your help. Ralph