This is my very first post, so I apologize if it’s not descriptive enough or in the wrong thread.
I have a task that requires me to generate the same set of graphics (about 14) for roughly 8 different sets of data. The data sets are in almost identical formats, but require some data transformations prior to creating the graphics.
Firstly, I’m looking to do this as efficiently as possible and I’m wondering if this process would best be completed through Macros, or a combination of different techniques (i.e., templates, manual data cleaning, and manual copy-pasting the data, using an “offset” command, recording macros). What would you all suggest?
Secondly, I have almost no knowledge of macros so any help there would be great.
To reiterate, I’m curious on how best/ideal to go from data to graphics in a more automatic and efficient way.
Thank you.
Bookmarks