Printing Problems

Print All Embedded Excel Charts Without PivotTables

Anum MushtaqAnum Mushtaq Nov 18, 2026 868 views

Question details

Print embedded charts from multiple Excel worksheets without printing PivotTables or other worksheet content.

Print All Embedded Excel Charts Without PivotTables
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the VBA editor

In desktop Excel, open the workbook and select Developer > Visual Basic. On Windows, you can also press Alt+F11.

2
Insert the macro

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

3
Run the macro

Place the cursor inside PrintEmbeddedCharts and select Run > Run Sub/UserForm, or press F5. Each embedded chart is sent to the active printer.

4
Save the macro if needed

To keep the macro in the workbook, choose File > Save As and select Excel Macro-Enabled Workbook (.xlsm).

Print Every Embedded Chart with a VBA Macro
Check the printer first: The macro sends charts directly to the active printer without showing a preview for each one. Review the printer selection before running it.
Free Microsoft Office alternative

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.

View and work with spreadsheet charts in WPS SpreadsheetsOpen and save Microsoft Excel formats, including .xlsxUse a familiar interface to ease migration from ExcelAccess a free, lightweight office suite
microsoft office alternative - wps office

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.