Different page setup on same sheet

[karate718]

Hi,

I have a two page worksheet that I would like to print. There is a lot of information and data on page 1. I have put two pie charts below it that will print on page 2. I used the page break preview to make sure all of the data prints on page 1 and the graphs will print on page 2. However, because page 1 is scaled down to roughly 43%, it does the same to the graphs. So the graphs become very small on page two and only take up the top third of the page.

Is there a way to apply different options so that all of the data is scaled to fit on page 1 and a different and more appropriate scale ratio is applied to the 2nd page?

Thank you.

 

[karate718]

Sorry, one other detail. I tried doing this with custom views which will work. However, this is a "template" sheet that I move into different workbooks. The Custom views don't carry over with that.

Thanks.