Copy Charts from Excel to Word
I have a 'Summary' sheet that has a drop down list of names of plots
(i.e. Plot 1, Plot 2, Plot 3, etc.). A corresponding tab named Plot
changes based on the plot name listed in the drop down box. (i.e. if
you select Plot 3 in the drop down list, Plot 3 appears on the Plot
tab).
There are 60 plots in the drop down list. I want to copy all 60 plots
to a document in Word and size them such they are about 4" tall.
Manually, I could choose plot in the drop down, click on the Plot tab
and copy and paste and do this 60 times. Hopefully there is an easier
way???
There are different ways the current spreadsheet might be working to
implement the drop down box. To approach your question, let's ask, "where's
the text of the different plots now?" In the spreadsheet itself (maybe
hidden)? In other documents?
|