Printing the Charts in the Report
To print an embedded chart as part of the surrounding data on the same worksheet, you simply print the worksheet (File → Print or Ctrl+P). To print an embedded chart by itself without the supporting worksheet data, click the chart to select it and then choose File → Print. Note that you can also print the embedded chart by putting it in its own window (right-click on the embedded chart and then select Chart Window on its shortcut menu) before you select the Print command. To print a chart that's on a separate chart sheet, activate its chart sheet tab and then choose File → Print or press Ctrl+P.
When printing a chart alone - that is, without its supporting data or in its own chart sheet or chart window - the Page Setup dialog box includes a Chart tab that contains its own special chart printing options:
Use Full Page: Click this option button to print to scale the chart so that it takes up the entire page.
- Scale to Fit Page:
Click this option button to have Excel scale the chart so that it prints on the page size you have selected.
Click this option button to print the chart in the size it assumes on the screen.
- Draft Quality:
Select this check box to print the chart by using your printer's draft-quality setting.
- Print in Black and White:
Select this check box to have your color printer print the chart in black and white.
Note that when you place an embedded chart in its own chart window, you can open the Page Setup dialog box to change these print settings on the Chart tab by right-clicking on the title bar and then clicking Page Setup on the window's shortcut menu.
In this tutorial:
- Printing Tricks for Reports
- Making Last-Minute Adjustments with Print Preview
- Manipulating the margins and column widths
- Controlling Page Breaks
- Using the Page Break Preview feature
- Changing the scale of the printing
- Adding Headings to Your Report
- Headers and footers made to order
- Printing the Formulas in the Report
- Printing the Charts in the Report