martinctc
4/25/2017 - 10:00 AM

Change colour of all points on scatter points in PowerPoint Chart

Change colour of all points on scatter points in PowerPoint Chart

Sub FormatScatterPointsColour()

Dim i, j As Long
Dim sld As Slide
Dim shp As Shape
Dim sr As Series
Dim chrt As Chart
    For Each sld In ActivePresentation.Slides
        For Each shp In sld.Shapes

            If shp.HasChart Then
                j = shp.Chart.FullSeriesCollection.Count
                For i = 1 To j
                    shp.Chart.FullSeriesCollection(i).Format.Fill.Visible = msoTrue
                    shp.Chart.FullSeriesCollection(i).Format.Line.Visible = msoTrue
                    shp.Chart.FullSeriesCollection(i).Format.Fill.ForeColor.RGB = RGB(107, 156, 107)
                    shp.Chart.FullSeriesCollection(i).Format.Line.ForeColor.RGB = RGB(107, 156, 107)
                    shp.Chart.FullSeriesCollection(i).HasLeaderLines = True
                Next
            End If
    Next shp
    Next sld
End Sub