Retrieving chart numbers where category names are non-numeric
Dear Experts:
attached sample files shows several pie charts.
I wonder whether it is possible using VBA ....
... to retrieve the chart numbers of the charts where the category name is text (not numeric).
This applies for Chart No. 2 and Chart No. 7
I have attached a sample file for your convenience.
Help is much appreciated. Thank you very much in advance.
Regards, Andreas
Retrieving-Chart-Numbers.xlsm
attached sample files shows several pie charts.
I wonder whether it is possible using VBA ....
... to retrieve the chart numbers of the charts where the category name is text (not numeric).
This applies for Chart No. 2 and Chart No. 7
I have attached a sample file for your convenience.
Help is much appreciated. Thank you very much in advance.
Regards, Andreas
Retrieving-Chart-Numbers.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Rory Archibald
Oh yes - thanks. (misread the question) :)
ASKER
HI rorya and ramanhp:
great works like a charm. Thank you very much for your great/professional support.
As a matter of fact I also would like to know how the code would look like if just/simply the chart number is returned instead of the name of the parent ChartObject.
Regards, Andreas
great works like a charm. Thank you very much for your great/professional support.
As a matter of fact I also would like to know how the code would look like if just/simply the chart number is returned instead of the name of the parent ChartObject.
Regards, Andreas
Change line 10 to:
strCharts = strCharts & ", " & Cht.IndexASKER
Thank you very much for your superb and swift support.
Regards, Andreas
Regards, Andreas