Hi,
I have a excel file with 20 charts in a single tab. When i take print of the tab/File first three charts are printing in the first page and half of the fourth chart is printing in fisrt page. Remaining half is printing in second page.
Please suggest a solution for this. Chart has no fixed length and number of charts in a sheet may vary depending on the requirement.
Please attach a sample of your workbook so we do not need to re-create your data to find a solution. Remember to remove/replace sensitive info before uploading the file.
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution.Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
Hello,
Use the Page layout or the Page Break view and position the charts so they don't spread across a page break. You may need to insert columns or rows. You may need to reduce a chart's size.
After a print preview, the Excel sheet will show dashed lines to indicate where page breaks will be. These can also be used as a guide to position content.
Finally, there is the option to scale the printout. That is a setting in the page setup dialog.
cheers, teylyn
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks