How to Fix Excel Charts Changing Size or Cropping When Saved as PDF
Question details
Users need to resolve an issue where specific charts inside a workbook distort or crop during the PDF conversion process.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Exporting or saving a spreadsheet containing charts into a PDF format for sharing or printing.
- Observed behavior
- Selected charts become unexpectedly enlarged, skewed, or cropped in the resulting PDF file, while other charts in the same workbook export correctly.
Verify that your chart is placed well within the defined print area of your sheet and ensure your default system printer is set to a virtual PDF printer, as Excel relies on printer drivers to render layouts.
Adjust Excel Page Layout and Print Area Settings
Properly configuring the print area and scaling settings directly in Excel often resolves chart distortion during PDF export.
Excel's 'Save as PDF' function heavily relies on your current page layout settings. If a chart crosses the boundary of a defined print area or if scaling is set incorrectly, it can become cropped or skewed in the output document.
Highlight the cells that contain your chart and any surrounding data you wish to include in the PDF.
Navigate to the 'Page Layout' tab on the ribbon, click 'Print Area', and select 'Set Print Area'.
In the 'Page Layout' tab, click the small dialogue box launcher in the 'Page Setup' group. Under the 'Page' tab, set scaling to 'Fit to 1 page wide by 1 tall' if applicable.
Go to File > Export > Create PDF/XPS Document, and publish the file to check if the chart retains its correct dimensions.
Use the Microsoft Print to PDF Feature
Bypassing the native 'Save As PDF' export tool and using the virtual printer can yield more accurate rendering results for charts.
Verify Your PDF Creation Software
Ensure you are using capable software, as basic PDF readers cannot generate PDFs from Excel files.
Use WPS Office to Prevent Chart Cropping in PDFs
If Microsoft Excel continues to crop or skew your charts during PDF conversion, consider switching to WPS Office. It provides a lightweight, highly compatible alternative with a robust, built-in PDF converter that accurately preserves all chart layouts exactly as they appear on your screen.
- 1. Open your file in WPS Office: Launch WPS Spreadsheet and open your existing .xlsx workbook.
- 2. Export to PDF: Go to the 'Menu' tab and select 'Export to PDF'.
- 3. Save the document: Confirm your export settings and click 'Export' to generate a perfectly formatted PDF with intact charts.
Frequently Asked Questions
Why does Excel change my chart size when saving as PDF?
This usually happens due to a mismatch between Excel's page setup, the selected print area, and your default printer driver settings. Excel relies heavily on printer drivers to render the layout for PDF exports, which can sometimes cause chart dimensions to distort.
Can Adobe Acrobat Reader convert Excel to PDF?
No, Adobe Acrobat Reader is a free PDF viewing application and does not have the capability to create or convert Excel files to PDF. To perform a conversion, you need Adobe Acrobat Pro, Microsoft Excel's native export tool, or an alternative like WPS Office.
How do I lock my chart's size before exporting to PDF?
Right-click the chart in Excel, select 'Format Chart Area', navigate to 'Size & Properties', and under the Properties section, select 'Don't move or size with cells'. This will help prevent unintended resizing during export or printing.
