How to Shrink a Chart to Fit on a Page in Excel

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.

Excel Sample Chart click

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.

Excel Ribbon File 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.

See also  How to Create a Timeline Chart in Excel