I've never done any graphing with macros earlier.
However, it would be nice to know how to perform operations like this one.
If I have say 'x' number of sheets and I want to trace and compare the graphical evolution of values on two particular columns on each sheet, what would be the simplest way to code it?
In the attached file, I have only three sheets. But, I am more looking for something that will help me easily loop through 100-150 sheets.
Assuming I insert a new sheet, could values from there be traced on to the new sheet too?
Also, is there any was of making it optional? Say, I want to view only graphs from particular sheets to compare them.
If the values were on the same sheet, I could have easily used the sort function to display a dynamic graph for me.
Thank you for your help in advance!
Bookmarks