Cartoper,
If I understand you. One sheet in the workbook has all the charts that you
want to print each week, one chart per page.
The easiest way to do this(I like easy) is to go to worksheet with the
charts on them.
Select view, and page break preview.
Now arrange the charts so each one is in its own blue box(dashed lines).
If you select the preview icon, or File, Print Preview.
You will be able to see each Chart per page. You may have to adjust so they
are centered, vertically, or horizontally positioned for your taste.
"Be Prepared"
hth
> I am working on a basic Excel spreadsheet for my son's Boy Scout
> Troop. There is one page that has all the charts on it. Weekly I
> need to print all the charts, one per page. How do I go about doing
> that? Might there be an easy macro I could write that would iterate
> through all the charts printing them?