Printing Problems

Fix Excel Charts That Shrink or Change Size When Printing

Amos GikundaAmos Gikunda Nov 18, 2026 869 views

Question details

The user needs to keep copied Excel charts and their text boxes at the intended size and alignment when printing.

Fix Excel Charts That Shrink or Change Size When Printing
Product
Microsoft Excel
Device & OS
not provided
Scenario
Printing copied charts embedded in a worksheet or placed on separate chart sheets.
Observed behavior
Charts may shrink or change size in Print Preview, and chart areas and text boxes may become misaligned.
Before you start

Identify whether the chart is embedded in a worksheet or on its own chart sheet, since each has separate print settings. If a similar chart prints correctly, compare its dimensions and page setup with the affected chart.

Solution 1Recommended

Check the worksheet and embedded chart settings

Use this approach when a chart placed on a worksheet shrinks or its text boxes shift in Print Preview.

1
Compare chart dimensions

Select the affected chart, right-click its chart area, and open Format Chart Area. Check its size and properties against a chart that prints correctly.

2
Review the page layout

Open Page Layout and check Size, Orientation, and Margins. Under Scale to Fit, review the width, height, and scale settings; fitting a worksheet to fewer pages can shrink its contents.

3
Check the print area

On the worksheet, open Page Layout > Print Area and review or reset the print area so it includes the intended chart and surrounding content.

4
Set object positioning

Right-click the chart and open Format Chart Area or Format Object > Properties. Choose Move and size with cells if the chart should follow cell changes, or Don't move or size with cells if it should stay fixed.

5
Reposition chart text boxes

Select the chart and inspect its text boxes. If a text box was copied outside the chart boundary, select the chart first, then use Insert > Text Box to recreate it inside the chart area.

6
Preview the result

Open File > Print and check the preview. Adjust the Page Layout settings or chart placement if the printed size or alignment is still incorrect.

Check the worksheet and embedded chart settings
Scaling affects printed size: A chart can have the correct dimensions on the worksheet but still appear smaller in print if the worksheet is scaled to fit the page.
Free Microsoft Office alternative

Work with spreadsheet charts in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files, review charts and print layouts, and move between office applications with ease.

Review spreadsheet charts and print layouts in WPS SpreadsheetsCompatible with Microsoft Excel XLS and XLSX formatsFamiliar interface for working with spreadsheetsFree and lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel chart look smaller in Print Preview?

Worksheet scaling may be reducing the chart to fit the selected print area on the page. Check Page Layout > Scale to Fit and review the settings under File > Print.

How do I stop an embedded chart from changing with cell sizes?

Right-click the chart, open Format Chart Area or Format Object > Properties, and select Don't move or size with cells.

Why are my chart's text boxes misaligned after copying?

A text box may have been copied outside the chart boundary. Select the chart first, then use Insert > Text Box to recreate the text inside the chart area.

Do worksheet print settings apply to a separate chart sheet?

A chart sheet has its own page setup. Select its sheet tab, open File > Print > Page Setup, and check its paper size, orientation, margins, and available chart print options.