Printing an Excel 2007 Chart
10 of 10 in Series: The Essentials of Working with Pivot Tables and Pivot Charts in Excel 2007
Printing a chart in Excel 2007 is a breeze, but the method you choose for printing the chart depends on whether you want to print an embedded chart (with or without the surrounding worksheet data) or a separate chart sheet:
To print an embedded chart as part of the data on the worksheet, you simply print the worksheet (from the Print dialog box; press Ctrl+P).
Before you print an embedded chart along with worksheet data, view the chart in the Page Layout or Page Break Preview view. You may need to move or resize the chart so that it fits nicely on the page.
To print an embedded chart by itself without the supporting worksheet data, click the chart to select it before you press Ctrl+P to open the Print dialog box, where the Selected Chart option button will automatically be selected in the Print What section.
To print a chart that’s on a separate chart sheet, activate the chart sheet by clicking its sheet tab and then press Ctrl+P to open the Print dialog box, where the Active Sheet(s) option button is automatically selected in the Print What section.
When you want to print an embedded chart alone (without its supporting data) or in its own chart sheet, you may want to select the Printing Quality options on the Chart tab of the Page Setup dialog box before sending the chart to the printer. Select the chart and click the Page Setup dialog box launcher on the Page Layout tab of the Ribbon to open the Page Setup dialog box with the Chart tab available. The Print Quality options on the Chart tab include the following:
Draft Quality: Select this check box to print the chart 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.Enable faster chart printing with the Printing quality settings in the Page Setup dialog box.