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.
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.