Fix Excel Charts That Shrink or Change Size When Printing
Question details
The user needs to keep copied Excel charts and their text boxes at the intended size and alignment 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.
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.
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.
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.
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.
On the worksheet, open Page Layout > Print Area and review or reset the print area so it includes the intended chart and surrounding content.
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.
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.
Open File > Print and check the preview. Adjust the Page Layout settings or chart placement if the printed size or alignment is still incorrect.

Review print settings for a separate chart sheet
Use this approach when the chart occupies its own sheet rather than being embedded in a worksheet.
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.

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.




