I think a class is a better way to manage all custom objects, and I am reading this that you want a custom object(s), albeit implementing a standard Excel object (a chart).

I will knock up a quick demo, not necessarily based on your post but of a chart manager class, and post that later, We can then dicuss from there, building it or whatever based upon our chat.