You can print an embedded Excel chart without its worksheet by simply selecting the chart and choosing File | Print or clicking the Print button. But what if you want to print the worksheet without the embedded chart? You could select the worksheet, choose File | Print, click Selection, and then press OK. But if it is a large worksheet spread out over nonadjacent cells, this method can be quite cumbersome. You can print the worksheet without the chart, and save yourself some mouse clicks, by following these steps:
- Right-click the chart and choose Format Chart Area.
- Click the Properties tab.
- Clear the check mark from the Print Object check box, and click OK.
Now you can use File | Print to print the entire worksheet without the embedded chart.
Miss a tip?
Check out the Microsoft Excel archive, and catch up on our most recent 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.