How to Print Chart Sheets in Excel: 2 Easy Ways
If your workbook contains both data worksheets and chart sheets, printing only the chart sheets is not always as straightforward as it seems. You may want to print just the charts for a report or presentation without including the underlying data sheets, but selecting the right sheets can be time-consuming, especially in a large workbook. In this guide, you will learn 2 easy ways to print chart sheets in Excel, including the built-in method and a more efficient Kutools solution, along with the difference between chart sheets and embedded charts.
What are chart sheets in Excel
A chart sheet in Excel is a separate sheet that contains only a chart. Unlike a normal worksheet, it does not display rows and columns for data entry. This makes chart sheets useful when you want to present or print charts on clean, standalone pages.
This is different from an embedded chart, which is placed inside a regular worksheet together with your source data. If your goal is to print only chart sheets, Excel allows you to select those chart sheet tabs and print them without printing the other worksheets in the workbook.
📢 Note: This article focuses on chart sheets, which are standalone chart pages. If your charts are embedded inside regular worksheets, see the Chart sheets vs. embedded charts section below.
Method 1: Print chart sheets with Excel's built-in feature
Excel lets you print one or multiple chart sheets directly. This method works well when you only need to print a small number of chart sheets occasionally.
1. Open the workbook that contains the chart sheets you want to print.
2. Click the chart sheet tab you want to print.
3. Click File > Print .
4. Choose your printer and other print settings, then click Print.
Result: Only the selected chart sheets are printed, while the regular worksheets remain unprinted.
- Built into Excel: No additional tools are required.
- Easy for simple tasks: Works well when you only need to print one or a few chart sheets.
- Direct and straightforward: You can print selected chart sheets directly from the Print menu.
- Manual selection is required: You need to click each chart sheet tab yourself.
- Less efficient for large workbooks: It can take time when many sheets are involved.
- Easy to miss the right sheets: It is less convenient when chart sheets are scattered throughout the workbook.
Method 2: Batch print chart sheets more easily with Kutools
If you often work with larger workbooks, using Kutools for Excel can make printing chart sheets more convenient. Instead of manually selecting chart sheet tabs one by one, Kutools helps streamline workbook and sheet management, which can save time when handling batch printing tasks.
1. Put the workbooks you want to print into the same folder.
2. In Excel, click Kutools Plus > Printing > Print Multiple Workbooks Wizard.
3. In the Step 1 wizard, choose All files to be printed are in the same directory, and click Next.
4. In the Step 2 wizard, click Browse to select the folder that contains the workbooks, make sure Excel workbooks is checked, and then click Next.
5. In the Step 3 wizard, choose Chart sheets only. Then only the chart sheets in the selected workbooks will be checked automatically. Click Next.
6. In the Step 4 wizard, specify the printing settings you need, and then click Finish to start printing.
Result: Only the chart sheets in the selected workbooks are printed, which saves time and avoids manually selecting sheets one by one.
- Batch prints chart sheets from multiple workbooks in one go
- Automatically selects only chart sheets in the chosen workbooks
- No need to manually click chart sheet tabs one by one
- More efficient when workbooks are stored in the same folder
- Helps save time when you need to print chart sheets repeatedly
- More convenient for handling multiple workbooks at once
- Easy to use with a clear step-by-step wizard
Excel vs. Kutools: which method should you use?
Both methods can help you print chart sheets in Excel, but the better choice depends on how often you do this and how complex your workbook is.
| Method | Best for | Advantages | Limitations |
|---|---|---|---|
| Excel built-in feature | Printing one or a few chart sheets occasionally | ✅ No add-in required; easy for simple tasks | ⚠️ Manual tab selection can be slower in large workbooks |
| Kutools for Excel | Handling chart sheets more efficiently in larger or more complex workbooks | ✅ More convenient for batch handling and repeated tasks | ℹ️ Requires Kutools for Excel |
Choose Excel's built-in feature if you only need to print a few chart sheets from time to time and want a simple solution without installing anything extra.
Choose Kutools if you often work with larger workbooks and want a more efficient way to manage and print the sheets you need.
Chart sheets vs. embedded charts
Before printing, it is important to know whether your chart is on a chart sheet or embedded in a regular worksheet, because the printing approach is different.
| Type | Description | Printing behavior |
|---|---|---|
| Chart sheet | A standalone sheet containing only one chart | Can be selected and printed as its own sheet |
| Embedded chart | A chart placed inside a normal worksheet with data | Usually prints together with the worksheet unless handled separately |
If your chart is embedded in a worksheet rather than placed on a chart sheet, you may need to select the chart itself or move it to a chart sheet before printing it as a standalone page.
Frequently asked questions
Can I print only chart sheets without printing worksheets in Excel?
Yes. Select only the chart sheet tabs you want to print, then go to File > Print. Excel will print only the selected chart sheets.
Can I print multiple chart sheets at once in Excel?
Yes. Hold Ctrl and click multiple chart sheet tabs, then print them together.
What is the difference between a chart sheet and an embedded chart?
A chart sheet is a separate sheet that contains only a chart. An embedded chart is inserted inside a regular worksheet together with the source data.
Can I print embedded charts only in Excel?
Yes, but the process is different. Because embedded charts are not separate sheets, you usually need to select the chart directly or move it to a chart sheet first.
Which method is better for large workbooks?
If your workbook contains many worksheets and chart sheets, Kutools is generally more convenient because it can make sheet handling faster and reduce manual work.
Printing chart sheets in Excel is easy when you only need to handle a few standalone chart pages. Excel's built-in feature is enough for occasional use, while Kutools can be a more convenient choice when you need to manage and print chart sheets more efficiently in larger workbooks.
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite — Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license — set up in minutes (MSI-ready)
- Works better together — streamlined productivity across Office apps
- 30-day full-featured trial — no registration, no credit card
- Best value — save vs buying individual add-in
Table of Contents
- What are chart sheets in Excel
- Method 1: Print chart sheets with Excel's built-in feature
- Method 2: Batch print chart sheets more easily with Kutools
- Excel vs. Kutools: which method should you use?
- Chart sheets vs. embedded charts
- Frequently asked questions
- The Best Office Productivity Tools
Kutools for Excel
Brings 300+ advanced features to Excel
- 🧩 Overview
- 📥 Free Download
- 🛒 Purchase Now
- 🎁 30-Day Free Trial available