How to Fix Excel Chart Points Shifting When Exporting to PDF
Question details
The user is experiencing formatting issues where data points in a scatter chart are misaligned or missing after exporting the Excel workbook to a PDF file.
- Product
- Microsoft Excel 365
- Device & OS
- not provided
- Scenario
- Exporting an Excel workbook containing a scatter chart to a PDF document.
- Observed behavior
- The scatter chart appears correct in Excel's Print Preview, but the data points shift position or disappear completely in the final generated PDF.
Check if your Microsoft Office 365 installation has pending updates, as visual rendering bugs are frequently patched in newer versions. Ensure you save your current workbook before testing with new files or restarting the application in Safe Mode.
Test with a New Workbook to Isolate the Issue
Determine if the chart shifting issue is specific to a corrupted workbook or a system-wide Excel rendering bug.
By testing a completely new file with basic data, you can quickly find out if the problem is rooted in your current file's formatting or if it is a broader software issue with Excel's PDF exporter.
Open Excel and click on 'Blank workbook' to start a new file.
Type a small, simple dataset (e.g., 1 to 5 in two columns) and insert a basic scatter chart from the 'Insert' tab.
Navigate to 'File' > 'Export' > 'Create PDF/XPS Document' to export this new file.
Open the generated PDF. If the points render correctly, your original workbook might be corrupted or overly complex. If they still shift, the issue affects your entire Excel application.
Run Excel in Safe Mode
Disable third-party add-ins and background extensions that might be interfering with the PDF export process.
Copy the Chart to Microsoft Word
Use Microsoft Word's PDF rendering engine as a workaround to preserve the chart's formatting.
Export Scatter Charts to PDF without Shifting in WPS Office
If Excel continues to distort your charts during PDF export, open your workbook directly in WPS Office. WPS Office features an advanced, built-in PDF converter that perfectly preserves chart layouts, data point placements, and all visual elements exactly as they appear on your screen.
- 1. Open your Workbook in WPS: Launch WPS Spreadsheets and open your existing .xlsx file containing the scatter chart.
- 2. Verify the Chart Layout: Review the chart visually to ensure all data points and axes are displayed correctly without any misalignments.
- 3. Export to PDF directly: Click on 'Menu' > 'Export to PDF', configure your desired export settings, and click 'Export' to generate a flawless PDF document.
Frequently Asked Questions
Why do my Excel charts look different in PDF than in Print Preview?
This mismatch is often caused by Excel's graphical rendering engine handling scaling differently for screen displays versus PDF printer drivers. Sometimes, updating your printer drivers or installing the latest Office updates can resolve scaling discrepancies.
Can hidden rows or columns cause scatter chart points to disappear in a PDF?
Yes. If a chart references hidden data and the chart settings are not explicitly configured to 'Show data in hidden rows and columns', those specific data points may fail to render properly when the file is exported or printed.
Does using 'Save As PDF' work better than 'Export to PDF'?
In some cases, using 'File' > 'Save As' and selecting PDF from the file type dropdown utilizes a slightly different conversion path than the 'Export to PDF' button. This alternative method might successfully bypass specific chart rendering bugs in Excel.
How do I sanitize a workbook before sharing it for troubleshooting?
To sanitize a file, create a copy of your workbook, delete any sheets not related to the chart, and replace sensitive data with dummy numbers (like 1, 2, 3). Make sure the scatter chart still demonstrates the shifting issue with the dummy data before sharing it.
