Chart & Visualization Issues

Fix Excel Bar Chart Looks Different in Print Preview

Aamir Naveed AkramAamir Naveed Akram Nov 10, 2026 870 views

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.

How to Fix an Excel Chart That Looks Different in Print Preview
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.
Before you start

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.

Solution 1Recommended

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.

1
Change the active printer

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.

2
Verify page scaling

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.

3
Check paper size and orientation

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.

Adjust Active Printer and Page Layout Settings
Testing Printer Drivers: If changing the printer to a virtual PDF printer resolves the issue, you may need to uninstall and reinstall your physical printer's drivers.
Print Charts Accurately

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. 1. Open your spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx file that contains the bar chart.
  2. 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. 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.
Accurate WYSIWYG print preview prevents layout distortionBuilt-in, high-quality Export to PDF tool without format shiftingFull compatibility with Microsoft Excel (.xlsx) file formatsFree, lightweight, and easy-to-use Office suite
microsoft office alternative - wps office

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.