Print hundreds of 6 column charts using maximum page for printing

Hello

I am using Excel 2010 and need some help.

I have over 800+ pages of chart that only takes up 6 columns and around like 9000+ rows.

I wanted to print this chart on paper and need hardcopies. However, the chart in its current setup prints only on the left half of the page leaving the right half empty.

How do i make use of the full space properly? Each chart has a "page number" on it so I want the chart to print continuously from one half of the page onto the next half and then the second page, third, etc.

Here is a visual demonstration of how things currently are and how i'd like to get them to be:

As you can see, This is the first of many charts and its numbered Page 9 and next one is page 10.

Pic1

How this looks when i try to print, it's only on the left side. right is all blank
Pic2

How i want it to look like upon printing
Pic3

As you can see in the last picture, once page 14 chart has no space it automatically continues chart on right side of page and then moves on to print rest.

Please tell me how i can achieve this because this is the best use of space or else i'm only using half the page and wasting a lot of paper.

cross posted: http://www.mrexcel.com/forum/excel-q...ml#post3457346

I'm afraid you are going to have to physically move your tables so they are side by side on the print page..
Given there are so many, it would probably be best to do it through code. Once you have tables aligned you can go to print preview and arrange the blue page borders accordingly.

In Print Preview mode you can adjust the position of the blue page borders so they frame your tables ..i.e upscale the display to fill the page.

Hi, simgs,

I'm afraid your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

Ciao,
Holger

No... Don't stretch the page - Hover the cursor over the blue page line (the cursor will change to resize arrows) and move the line towards the charts. Make sure you are in page break view mode.