Fix Excel Charts Cut Off When Printing or Saving to PDF
Question details
The bottom or right side of charts is missing or truncated when printing to a physical printer or exporting to a PDF file.
- Product
- Microsoft Excel
- Device & OS
- Windows 10
- Scenario
- Printing a worksheet containing charts or saving the document as a PDF.
- Observed behavior
- The chart looks perfectly aligned and fully visible in Print Preview, but the final printed page or PDF document has the bottom and right edges cut off.
Make sure your printer drivers are up to date and that you have actively selected your target printer or PDF software before adjusting your page layout settings.
Lower the Print Resolution to 300 DPI
Reducing the print quality resolution resolves internal Office scaling bugs that cause charts to render larger than the page boundaries.
In certain Office 365 and Windows 10 updates, high-resolution printing (600 DPI or 1200 DPI) triggers a scaling issue where charts do not fit the paper properly. Lowering the DPI to 300 forces the application to scale the chart correctly without noticeably degrading the quality of standard graphics.
Navigate to the 'Page Layout' tab on the Excel ribbon and click the small dialog box launcher in the bottom-right corner of the Page Setup group.
On the 'Page' tab of the Page Setup window, locate the 'Print quality' dropdown menu.
Change the resolution from 600 dpi (or higher) to 300 dpi, then click 'OK' to save the settings.
Proceed to print your document or export it to PDF to verify the chart is fully visible.
Change the Default Printer and Adjust Scaling
Excel sometimes uses printer-dependent layouts. Selecting the correct printer before previewing and enforcing a 'Fit to Page' rule can prevent chart cutoff.
Print and Export Charts Flawlessly with WPS Office
If you frequently experience layout issues and cut-off charts in Microsoft Excel, try using WPS Spreadsheet. It features a highly accurate print rendering engine and a built-in PDF exporter, ensuring that what you see on your screen perfectly matches your final printed page.
- 1. Open Your Workbook: Launch WPS Spreadsheet and open your existing Excel (.xlsx) file containing the charts.
- 2. Access the Print Menu: Click on the 'Menu' button in the top-left corner and select 'Print' or 'Export to PDF'.
- 3. Adjust Scaling Settings: In the Print dialog, select your printer. Under the scaling options, choose 'Fit Sheet on One Page' to ensure the layout is perfectly bounded.
- 4. Print or Save: Click 'Print' or complete the PDF export process to get a complete, uncut chart output.
Frequently Asked Questions
Why does my Excel chart look completely fine in Print Preview but cut off when printed?
Print Preview relies on screen rendering calculations, while the actual printing process communicates with your specific printer's driver (or PDF software) using DPI scaling. If there is a mismatch or a bug in the scaling process between the software and the driver, the edges of the chart will exceed the physical page margins during output.
Does using 'Microsoft Print to PDF' solve the chart cutoff issue?
Sometimes. Switching from a third-party exporter like Adobe Acrobat to Windows' native 'Microsoft Print to PDF' can bypass specific third-party driver bugs. You can select this option in the Printer dropdown on the Print page.
Will reducing the print resolution to 300 DPI make my chart blurry?
For most standard line, pie, and bar charts, lowering the resolution to 300 DPI will not noticeably affect visual quality on a standard page size. It successfully resolves the scaling issue without compromising the clarity of simple graphics, though extremely small text might appear slightly less sharp than at 1200 DPI.
