Microsoft Office Tutorials and References
In Depth Information
Working with Charts
Printing embedded charts is nothing special; you print them the same way that you print a
worksheet. As long as you include the embedded chart in the range that you want to print, Excel prints
the chart as it appears on-screen. When printing a sheet that contains embedded charts, it’s a good
idea to preview first (or use Page Layout view) to ensure that your charts don’t span multiple pages. If
you create the chart on a chart sheet, Excel always prints the chart on a page by itself.
If you select an embedded chart and choose File Print, Excel prints the chart on a page ➜
by itself (as though it were a chart sheet) and does not print the worksheet.
If you don’t want a particular embedded chart to appear on your printout, select the background
area of the chart (the chart area), right-click, and choose Format. In the Format Chart Area dialog box,
click the Properties tab and deselect the Print Object check box (see Figure 5-17).
Figure 5-17: Specifying that a chart should not be printed with the worksheet.