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

On Mar 29, 11:42 am, "ccfcrup" wrote:
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