Hello.
I have a big file with multiple sheets, each containing multiple charts.
By default, Excel names the chart objects ( 1 to n) in a sheet.
I need to create a list of all the chart objects in my workbook. How should I do this? i.e. a list that says : - Sheets(i), chartobjects("Chart 1")...and so on.
Basically, I am dynamically generating a different number of charts in a sheet, depending on my data, and I need to find out how many charts are contained in the workbook at the end. Potentially, I could use a variable in my code that keeps track of charts generated, but I would like to find the number of charts for previous files as well without going through the loop all over again.
To make things more interesting: What would happen if i grouped 4 charts together? How can i find out the group name through VBA?
All of this is part of a bigger code, where I am copy pasting(special) all these charts to generate a word document.
Any help would be extremely appreciated.
Thanks in advance
SG
I have a big file with multiple sheets, each containing multiple charts.
By default, Excel names the chart objects ( 1 to n) in a sheet.
I need to create a list of all the chart objects in my workbook. How should I do this? i.e. a list that says : - Sheets(i), chartobjects("Chart 1")...and so on.
Basically, I am dynamically generating a different number of charts in a sheet, depending on my data, and I need to find out how many charts are contained in the workbook at the end. Potentially, I could use a variable in my code that keeps track of charts generated, but I would like to find the number of charts for previous files as well without going through the loop all over again.
To make things more interesting: What would happen if i grouped 4 charts together? How can i find out the group name through VBA?
All of this is part of a bigger code, where I am copy pasting(special) all these charts to generate a word document.
Any help would be extremely appreciated.
Thanks in advance
SG