Is it possible to add charts to a custom collection?

[rkaczano]

Is it possible to create a custom collection and add Chart Objects to it?

I know their is an existing collection in the object model based on ActiveSheet.ChartObjects which I can loop through.

But I want to group two sets of charts (10 charts total but two groups of 5x charts) on a sheet so that I can manipulate the formatting via VBA.

So I want to create two custom collections, add the relevant charts to each collection. loop through each collection and then undertake separate VBA formatting for each collection.

Thanks

 

[StephenCrump]

When you say custom collection, it sounds like you're assuming a Class is required?

You can very easily add specified ChartObject's to a standard VBA Collection, and loop through the Collection. Have you tried doing this?

 

[rkaczano]

When you say custom collection, it sounds like you're assuming a Class is required?

You can very easily add specified ChartObject's to a standard VBA Collection, and loop through the Collection. Have you tried doing this?

Yes you are right - I had it in my head that I needed a custom collection - thanks for the feedback.