Hey Excel gurus,
I have a tricky problem to solve. I'm doing data analysis, and I have a few dozen files, each of which have between 1 dozen and 4 dozen bar graphs. The graphs in each file were produced by a macro unique to that file.
I want to go back and make changes that apply to every graph. This includes adding a text box with certain labels and statistical values, rescaling the graphs, and adding a new series that has the expected values (the data for which are already on the sheet).
I was wondering if the right way to do this would be to write a macro that deletes all existing graphs, edits the one macro in that file (always the same name in each file, luckily), and then reruns that macro. Is there a better way? Also, if I were to do it this way, how would I have my macro run another macro, or edit it?
Thank you!
I have a tricky problem to solve. I'm doing data analysis, and I have a few dozen files, each of which have between 1 dozen and 4 dozen bar graphs. The graphs in each file were produced by a macro unique to that file.
I want to go back and make changes that apply to every graph. This includes adding a text box with certain labels and statistical values, rescaling the graphs, and adding a new series that has the expected values (the data for which are already on the sheet).
I was wondering if the right way to do this would be to write a macro that deletes all existing graphs, edits the one macro in that file (always the same name in each file, luckily), and then reruns that macro. Is there a better way? Also, if I were to do it this way, how would I have my macro run another macro, or edit it?
Thank you!
