I would like to take plots that I am generating in excel through a macro and be able to arrange them on a single worksheet. For example, I have 10 plots that will be generated, and I would like to have all 10 plots reduced in size and arranged so that I can look at all 10 at the same time. If anyone can help that would be great!
Thanks!
Jonathan
What is a plot?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
A graph...like a scatter plot of data with an x and y axis
Copy and paste them as pictures, then resize them. Try the Macro Recorder for the basic code.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
Reply With Quote
