printing multiple charts per page

  • Thread starter Thread starter Pablo
  • Start date Start date
P

Pablo

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!
 
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
 
Back
Top