Software

Prevent embedded charts from printing in Excel 2002/2003

You may not always want to print Excel charts that are embedded in a worksheet. Luckily, you don't have to selectively print your data. See how to disable chart printing in Excel 2002/2003.

You have a number of embedded charts in your worksheet, and you don't want them to appear when you print it. With Excel 2002/2003, you don't have to select your data first and print the selection before you print the worksheet to avoid printing the charts. You just have to disable printing for the charts. Follow these steps to disable printing for each chart in your worksheet:

  1. Press Ctrl and click the chart to select its container.
  2. Go to Format | Object.
  3. In the Format Object dialog box, click the Properties tab.
  4. Deselect the Print Object check box.


Miss an Excel tip?

Check out the Microsoft Excel archive and catch up on other Excel tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox