Print All Embedded Excel Charts Without PivotTables
Question details
Print embedded charts from multiple Excel worksheets without printing PivotTables or other worksheet content.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A workbook contains embedded charts and PivotTables across multiple worksheets, but only the charts need to be printed.
- Observed behavior
- Printing the entire workbook also prints PivotTables and other worksheet content.
Open the workbook in desktop Excel and check that the intended printer is available. The macro method requires permission to run VBA macros; Excel for the web cannot run them.
Print Every Embedded Chart with a VBA Macro
Use a macro to print embedded charts across worksheets without printing the surrounding cells or PivotTables.
The macro prints each embedded chart directly. It does not print separate chart sheets, and it may stop if a chart cannot be printed, such as one on a hidden worksheet.
In desktop Excel, open the workbook and select Developer > Visual Basic. On Windows, you can also press Alt+F11.
In the VBA editor, select the workbook in the Project pane, choose Insert > Module, and paste this code: Sub PrintEmbeddedCharts() Dim ws As Worksheet Dim chartObj As ChartObject For Each ws In ThisWorkbook.Worksheets For Each chartObj In ws.ChartObjects chartObj.Chart.PrintOut Next chartObj Next ws End Sub
Place the cursor inside PrintEmbeddedCharts and select Run > Run Sub/UserForm, or press F5. Each embedded chart is sent to the active printer.
To keep the macro in the workbook, choose File > Save As and select Excel Macro-Enabled Workbook (.xlsm).

Print Selected Charts One at a Time
Use Excel's print preview when you have only a few charts or want to check each chart before printing.
Work with Excel Charts in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Excel-format support for an easier transition. It can help you view and work with charts, but it does not fix Excel's chart-printing workflow.

Frequently Asked Questions
Can I print one Excel chart without its PivotTable?
Yes. Select the chart's outer edge, choose File > Print, and check that the preview shows only the chart before printing.
Does the macro print charts on separate chart sheets?
No. The macro loops through embedded ChartObjects on worksheets. Print any separate chart sheets individually by opening each one and choosing File > Print.
Can I run the chart-printing macro in Excel for the web?
No. Open the workbook in desktop Excel and use Developer > Visual Basic to insert and run the VBA macro.
Why did the macro stop before printing every chart?
A chart may be on a hidden worksheet or otherwise unavailable to print. Check the worksheet and printer, then run the macro again; charts printed before the error may be printed a second time.




