How to Fix Excel Chart Bars That Do Not Print
Question details
The user is looking for a solution to an issue where chart bars in an Excel spreadsheet are visible on the monitor but do not appear on the printed document.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to print an Excel spreadsheet that contains a bar chart.
- Observed behavior
- The chart bars display correctly on the screen but disappear completely or fail to render when the document is physically printed.
Before modifying your print settings, ensure that your printer has sufficient ink or toner and that it prints standard text documents without any issues. It is also recommended to save your current workbook to avoid accidental data loss while adjusting page properties.
Adjust Print Area and Page Setup Settings
Checking the Print Preview and modifying the page layout ensures the chart is correctly scaled and positioned within the printable boundaries.
Often, charts fail to print because they fall outside the active print area or are cut off by the page margins. Forcing the sheet to scale properly can instantly resolve this.
Navigate to File > Print to view the Print Preview screen. Check if the chart bars are visible in the preview pane.
If the chart is too wide and gets cut off, change the page orientation from Portrait to Landscape in the print settings.
Under the Settings section, click the scaling drop-down menu and select 'Fit Sheet on One Page' to ensure all elements, including the chart, fit within the margins.
Alternatively, return to the worksheet, click directly on the chart to select it, and press Ctrl+P. This commands Excel to print only the chart, automatically scaling it to the paper size.

Verify Chart Formatting and Print Quality
Ensure the chart elements are not formatted as transparent and that Excel is not instructed to skip graphics during printing.
Update Printer Drivers and Software
Outdated drivers or bugs within the application can prevent visual elements like chart bars from communicating properly with your printer.
How to Print Spreadsheets and Charts with WPS Office
If you are experiencing persistent bugs with chart printing, WPS Office offers a highly reliable, lightweight spreadsheet application that accurately renders and prints your visual data.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing Excel workbook containing the chart.
- 2. Access Print Preview: Click on the 'Menu' button in the top-left corner, hover over 'Print', and select 'Print Preview'.
- 3. Adjust Print Settings: Ensure your page orientation is correct and scaling is set to fit the page so no chart elements are cut off.
- 4. Print Document: Once the chart is fully visible in the preview window, click the 'Print' icon to send it directly to your printer.

Frequently Asked Questions
Why does my Excel chart look fine on screen but print blank?
This commonly happens when the chart is positioned outside the active print area defined in your Page Setup. It can also occur if 'Draft quality' is checked in the sheet settings, which forces the printer to skip graphics to save ink.
Can changing the print quality fix missing chart bars?
Yes. If your printer's DPI (Dots Per Inch) is set too low or it is operating in an eco-mode, graphics like chart bars might be omitted. Increasing the print quality in your printer properties can resolve this issue.
How do I force Excel to print only the chart?
You can force Excel to print just the chart by clicking directly on the chart boundary to select it, then navigating to File > Print. Excel will automatically scale the selected chart to fill the printed page, ignoring the rest of the spreadsheet data.




