Fix Excel Bar Chart Looks Different in Print Preview
Question details
The user is trying to print or export an Excel bar chart, but the chart's appearance and layout change unexpectedly when viewed in Print Preview or saved as a PDF.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Preparing a completed Excel bar chart for physical printing or exporting to a PDF document for sharing.
- Observed behavior
- The chart renders correctly on the spreadsheet canvas but shifts, resizes, or distorts in Print Preview and in the final exported PDF.
Ensure your printer drivers are fully up to date and that you have installed the latest software updates for your spreadsheet application to prevent rendering bugs.
Adjust Active Printer and Page Layout Settings
Change the selected printer and verify page scaling options, as printer drivers directly influence how Excel renders charts in Print Preview.
Excel uses the default printer's driver to calculate page layout and margins. If the driver misinterprets the chart's dimensions, it will cause the preview to look different from the worksheet view.
Go to File > Print. Under the Printer section, click the dropdown menu and select a different printer, such as 'Microsoft Print to PDF', to see if the preview corrects itself.
While in the Print menu, click 'Page Setup' at the bottom. Under the Page tab, ensure the Scaling is set to 100% rather than an incorrect 'Fit to' value.
In the Page Setup dialog, verify that the selected Paper Size matches your intended output and that the Orientation (Portrait or Landscape) accommodates the chart's width.

Export as an Image or Copy to a New Workbook
Isolate the issue by converting the chart to a static image or moving it to a clean workbook to bypass spreadsheet corruption or layout bugs.
Print and Export Charts Flawlessly with WPS Spreadsheet
Avoid unexpected layout shifts when printing or exporting charts. WPS Spreadsheet offers highly compatible and precise WYSIWYG (What You See Is What You Get) print features to ensure your charts look exactly as designed.
- 1. Open your spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx file that contains the bar chart.
- 2. Preview the layout: Click on 'Menu' in the top-left corner, navigate to 'Print', and select 'Print Preview' to verify the exact layout.
- 3. Print or Export to PDF: Click the 'Print' icon directly from the preview window, or use 'Menu' > 'Export to PDF' to generate a distortion-free document.

Frequently Asked Questions
Why do Excel charts change size when printed?
Printers use different rendering resolutions (DPI) than your computer screen. If your page setup is set to scale improperly, or if the printer driver interprets the chart margins differently, the chart may resize or shift during the transition from screen to print.
How can I lock an Excel chart's proportions for printing?
Right-click the chart and select 'Format Chart Area'. Go to the 'Size & Properties' tab, expand 'Properties', and select 'Don't move or size with cells'. This helps prevent the chart from distorting if worksheet columns are adjusted before printing.
Does exporting to PDF fix chart printing issues?
Exporting to PDF often bypasses local hardware printer driver quirks. However, if Excel's internal print layout engine is already distorting the chart in Print Preview, the PDF will likely capture that same distortion. Saving the chart as a static image first is a reliable workaround.




