If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
printing multiple charts per page
Hello:
I have a worksheet that has approximately 60 charts. Each product's #s are illustrated in 3 charts, ie- I have 20 groups of 3 charts. Or, 20 products that have 3 charts. What I'm trying to do is have a simple way to print all of these charts. I'd like each product's charts (3) to be on one page. My problem is I set up a macro that selects the area around the charts and then prints, but if I insert rows/columns in my worksheet the macro print areas do not update and messes up the print out. Is there a way to select the 3 charts for each product and name those something I can put in my print macro? Any other ideas? Thanks! |
#2
|
|||
|
|||
printing multiple charts per page
Hi Pablo -
Here's where a little prior planning helps. With your empty worksheet, go to page setup and set everything the way you want. Return to the sheet, and you'll see the automatic page breaks. If not you can activate them using Options on the Tools menu; on the View tab, check Page Breaks under Window options. Now it's up to you to size and position your charts so they fit three per page. When you print, select a cell, not a chart, so the worksheet prints out. Each page of the sheet will have three charts, just like you arranged them. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ Pablo wrote: Hello: I have a worksheet that has approximately 60 charts. Each product's #s are illustrated in 3 charts, ie- I have 20 groups of 3 charts. Or, 20 products that have 3 charts. What I'm trying to do is have a simple way to print all of these charts. I'd like each product's charts (3) to be on one page. My problem is I set up a macro that selects the area around the charts and then prints, but if I insert rows/columns in my worksheet the macro print areas do not update and messes up the print out. Is there a way to select the 3 charts for each product and name those something I can put in my print macro? Any other ideas? Thanks! |
Thread Tools | |
Display Modes | |
|
|