Macro to toggle between object types within a given object

[#1]

I would like to create a Macro button to toggle between the object types Pivot Table and Line Chart within a single object. I would like to use this approach instead of use the fast access button in the object captions. Has anyone written a macro like this before? Thanks.

[boorgura]

You can use a macro to access the properties of the sheet objects like this:

ActiveDocument.getsheetObject("CHxxx").GetProperties

[boorgura]

Or the simplest way would be to have 2 charts - and hide/unhide them using a button action.