I am using the following code to copy a chart from one sheet and paste it as an image in another:
What can I add to this code to insert a page break after pasting the image in Sheet4? I have 200+ charts I need to copy and I would like each one to be on a different page in Sheet4.
Please Login or Register to view this content.
Hello Scrumbag,
This macro will copy the charts from "Sheet3" to "Sheet4" placing a page break after each chart. I changed the chart placement from across the worksheet to down. Since you are using Excel 2003 there are only 256 columns and you say you have 200 plus charts. You could easily run off the worksheet.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
That did the trick, thank you!
By chance is there a way to copy the chart without making it a picture? But I would want all of the data behind it to be static. Is that possible? For instance, once the chart is created with data from A1:A10, copy it statically and then another chart can be generated with different data from A1:A10 but the first chart not be affected?
Hello scrumbag,
I am not a Charting expert. You should start a new post in the Charting forum and provide a reference back to this post.
Will do! Thanks again for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks