In this lesson, you will learn how to shrink your chart so that it fits on the page. If you have a large Excel chart that you need to print, you may find that it doesn’t fit on a single page. This can be frustrating, but there are a few things you can do to shrink your chart without losing quality.
Using the ribbon
The first way to shrink your chart is to use the ribbon. To do this, follow these steps:
Select the chart that you want to shrink.
Click on the Page Layout tab.
In the Scale to Fit group, click on the “Width” and “Height” options and select “1 page” for both.
This will resize your chart to fit on a single page. You may need to adjust the chart’s formatting to ensure that it is still readable.
Changing the page settings
Another way to shrink your chart is to change the page settings. To do this, follow these steps:
Click on the File tab.
Click on Print.
Under Scaling, select “Fit Sheet on One Page”. Click Print.
This will print your chart on a single page, even if it is larger than the page size.
