Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Printing / February 2008

Tip: Looking for answers? Try searching our database.

Print charts

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Cartoper - 21 Feb 2008 12:25 GMT
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?
FloMM2 - 22 Feb 2008 08:29 GMT
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?

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.