How to Fix Incorrect Chart Sheet Scaling When Printing in Excel
Question details
The user needs to resolve an issue where an Excel chart sheet prints at the wrong scale or has parts cut off.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Printing an Excel chart sheet or exporting it to a PDF document.
- Observed behavior
- The chart prints at an incorrect scale, often resulting in parts of the chart being truncated or cut off from the final page.
Ensure your printer drivers are up to date and always use the Print Preview feature to check the layout before sending the document to the printer or exporting to PDF.
Fit the Chart to One Page in Print Settings
Adjust the page scaling options to ensure the entire chart fits perfectly on a single printed page without being cut off.
The most common reason for a chart being cut off is that the default scaling exceeds the printable area of the selected paper size. Forcing the sheet to fit on one page resolves this.
Click on 'File' in the top ribbon and select 'Print' to open the print preview and settings menu.
Scroll down to the bottom of the print settings panel and click on the 'Scaling' dropdown menu (which usually defaults to 'No Scaling').
Select 'Fit Sheet on One Page' from the dropdown list. Check the print preview to confirm the chart is now fully visible.
Move the Chart to a New Worksheet
If the dedicated chart sheet continues to scale poorly, embedding it into a standard worksheet offers better layout control.
Refresh Page Setup by Toggling Paper Size
Temporarily changing the paper size can force the software to recalculate and refresh the chart sheet's print settings.
Seamlessly Print and Export Charts in WPS Spreadsheet
WPS Office provides an intuitive print preview and page layout system, making it easy to scale charts, fit them to a single page, or export them to PDF without any unexpected cut-offs.
- 1. Open Your Workbook: Launch WPS Spreadsheet and open the file containing your chart.
- 2. Select the Chart: Click on the chart sheet or the specific chart object you want to print.
- 3. Access Print Preview: Go to Menu > Print > Print Preview to see exactly how the chart will look on paper.
- 4. Adjust Scaling: Click the 'Page Setup' icon in the preview window, select 'Fit to 1 page wide by 1 tall', and click 'Print' or 'Export to PDF'.
Frequently Asked Questions
Why is my Excel chart cut off when saving to PDF?
This happens because the default print area or scaling settings in the document do not match the dimensions of the PDF page size. Adjusting the scaling to 'Fit to One Page' in the Print menu before exporting resolves this issue.
Can I adjust margins on a dedicated chart sheet?
Yes, you can adjust margins by going to the Page Layout tab and selecting Margins, or by clicking the 'Show Margins' button in the Print Preview window and dragging the margin lines directly to create more space for the chart.
Does changing the printer affect chart scaling?
Yes, different printers have different default hardware margins and printable areas. Switching printers might cause the chart to scale differently. Toggling the paper size in Page Setup forces Excel to read the new printer's layout limits.
