Johannes
09-01-2004, 09:22 AM
Hi, every month I am distributing a set of reports containing several charts. The reports that I distribute are copies where I have converted formulaes to values. In order to create "dead" charts I go through the charts, click each chart series, press F2 and then F9 to convert the range references to arrays.
The alternative is to convert the chart to a picture, but I don't want to to that as I believe it increases the size of the workbook, and this alternative is not really much less timeconsuming and tedious than the other one!
So, how can I use VBA code to loop through each graph, and each series within the graphs and convert the range references to arrays?
I can always manage to write the code that loops through the charts and series, but the tricky thing that I cannot see any solution for is how to do the actual convertion from range refernces to arrays.
Any ideas will be greatly appreciated!
Johannes
The alternative is to convert the chart to a picture, but I don't want to to that as I believe it increases the size of the workbook, and this alternative is not really much less timeconsuming and tedious than the other one!
So, how can I use VBA code to loop through each graph, and each series within the graphs and convert the range references to arrays?
I can always manage to write the code that loops through the charts and series, but the tricky thing that I cannot see any solution for is how to do the actual convertion from range refernces to arrays.
Any ideas will be greatly appreciated!
Johannes