To print a chart in Excel, use the Print option from the File tab. Use the Settings menu to specify exactly what you want to print from your workbook.
Select the chart in your workbook.
Select File > Print.
Tip
Use the keyboard shortcut, Ctrl + P, to open the Print option.
Select the printer you want to use from the Printer dropdown.
Select Print.
Tip
Use the Settings option to choose the specific item you want to print. Under Settings, select Print Selected Chart to print only the chart, or select Print Entire Workbook to print the entire workbook.
Print a chart without worksheet data
You can print one chart without worksheet data per page.
- Select the chart that you want to print.
If the chart is on a separate chart sheet, select the chart sheet tab. - Select Print.
By default, Selected Chart is selected under Settings.
You can see how the chart will look on the printed page.
Note
You can't scale a chart before you print it. Instead, you can move and size the chart area of the chart to adjust it as needed. For more information, see Move or resize a chart.
Set page options for a chart
On the Page Layout tab, in the Page Setup group, click the Dialog Box Launcher
.
Do one or more of the following:
- On the Page tab, specify the orientation, paper size, print quality, and the page number of the first page.
Note
You can't adjust the scaling of a chart.
To quickly specify the orientation of the printed pages, on the Page Layout tab, in the Page Setup group, select Orientation, and then select Portrait or Landscape.
Set page margins for a chart
On the Page Layout tab, in the Page Setup group, click Margins.
Do one of the following:
- To use predefined margins, click the margin option that you want.
- To specify custom page margins, click Custom Margins, and then in the Top, Bottom, Left, and Right boxes, enter the margin sizes that you want.
- To set header or footer margins, click Custom Margins, and then enter a new margin size in the Header or Footer box. Setting the header or footer margins changes the distance from the top edge of the paper to the header or from the bottom edge of the paper to the footer.
Note
The header and footer settings should be smaller than your top and bottom margin settings, and larger than or equal to the minimum printer margins.
- To see how the margins affect the printed chart, click Print Preview. To adjust the margins in print preview, click Show Margins
(to the lower right of your screen) and then drag the black margin handles on either side and at the top of the page.
Note
You can't center the page horizontally or vertically for charts.
Change the print quality of a chart
- Select the chart that you want to print.
- On the Page Layout tab, in the Page Setup group, click the Dialog Box Launcher
.
- On the Chart tab, under Printed quality, select the Draft quality check box, the Print in black and white check box, or both.
To see the result of the print quality settings that you select, click Print Preview. - Select Print.