Store Chart Attribute in Chart Object

[DPTaylor]

I have a large number of charts in a workbook (and charts will be created and deleted via VBA code). They are all in one of two mutually exclusive categories, say A and B. I wish to test in VBA modules which category each chart is in. Where can I store this information?

[Izandol]

You may simply prefix chart name with A or B?

[DPTaylor]

I agree that changing the name would typically be a good solution; however, I was wondering whether there was a "spare" property I could use. The reason for this is that I am updating a complex addin which was written in 1999 and updated by many individuals since. It currently uses both .name and .parent.name for other reasons.

[Izandol]

If chart is embedded you may use AlternativeText property of parent shape:

Please Login or Register  to view this content.

or perhaps you may store value in chart's PageSetup properties?

[Andy Pope]

in addition to Izandol's suggestion there is the Title property

Please Login or Register  to view this content.

Or you could add a shape within the chartobject, hide it and simple use the text property

[DPTaylor]

Many thanks; I've decided to go with the the alternative text option.