Hi,
I've created a huge amount off data that needs to be crunched and graphed.
The data tables all show the same thing, valve angle vs pressure drop, but for different conditions.
I've attached a sample table showing one table, with an example graph next to it. For each of these tables I'm going to make 3 or 4 graphs in a row. However, i have about 30 of these tables in a column and don't like the idea of having to copy and paste the original graphs, then open up each graph to alter the links to the newest table.
Is there anyway to copy and paste graphs to many sets of data?
If this can't be done, what would be a better option. I haven't had any experience with VBA or macros, however i'm open minded to learn and use them if required.
Sample book.xlsx
Please post a link to anything if this has been answered before or any other useful links.
Thanks,
HJII
Bookmarks