I have a sheet and trying to get the all charts in the sheet. Used ActiveSheet.getSheetObjects and checked the object type and able to get the charts
But when the charts are placed in a container object, the charts are not retrieved by getSheetObjects method and also not listed in the
Settings > Sheet Properties > Objects list.
How to get those chart objects too?