Applying formats to graphs

[ccfcrup]

I have some formatting which I want to apply to a number of graphs on
a sheet. Can I apply the formatting to each chart without having to
enter each individual chart name?

Thanks

 

[ccfcrup]

I have some formatting which I want to apply to a number of graphs on
a sheet. Can I apply the formatting to each chart without having to
enter each individual chart name?

Thanks

I've answered my own question after doing a bit of digging.

n = ActiveSheet.ChartObjects.Count

For i = 1 To n
With WorkSheet("Name").ChartObjects(i).Chart
'Apply Formatting
End With
Next i