Prevent Charts from Printing in Excel

Add to Favorites
Author: | Edits: don

This is how you prevent a chart from appearing when you print from Excel.

This is a great feature when you want to hide a chart to better showcase data or for any other reason.

Here is our sample spreadsheet (download it from the side-menu to follow along):


Steps to Prevent a Chart from Printing in Excel

  1. Right-click the side of the chart and click Format Chart Area:fb0a1069d9faf974452dce9ffbaa62aa.jpg
  2. Go to the Properties section and un-check the option that says Print object7c572528d5035711c575d95fb4611210.jpg
  3. View the worksheet in Print Preview mode to make sure the chart will not be printed.8fb00f05d6f867aff8d3a7c87e423452.jpg

If you want to get the chart back, just follow the above steps but check the box next to Print object instead of un-checking it.

You can always test if the chart will be printed or not by going into the print preview mode.

Here is what our document would look like when printed if the chart was included:


You can format the resulting page however you want, but, now you know how to prevent a chart from appearing in the printed output from Excel.

Note: this feature also works with any shape or image in Excel.

Question? Ask it in our Excel Forum

Downloadable Files: Excel File

Similar Content on TeachExcel
Prevent Errors From Appearing in Excel
Tutorial: How to prevent errors from appearing in formulas in Excel. This is especially helpful for...
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
Macro: This free Excel macro illustrates all of the possible parameters and arguments that yo...
Scale Data for Printing in Excel - Fit more onto a Printed Page
Tutorial: This tip shows you how to fit more Excel data onto a page for printing. This does not chan...
Display The Actual Link / Email Address From Links in Excel - UDF
Macro: Display the actual link or email address from links within Excel with this UDF. This user ...
Get Text from Comments in Excel Including the Author of the Comment - UDF
Macro: Output all text from a cell comment, including comment author, with this UDF in Excel. Thi...
Remove All HTML from Text in Excel
Tutorial: How to quickly and easily remove all HTML from data copied into Excel. This tutorial inclu...