How to Print Only the Charts in Excel 2013
Sometimes, you may want to print only a particular chart embedded in the worksheet of Excel 2013 (independent of the worksheet data it represents or any of the other stuff you’ve added). To do this, open the Selection task pane and make sure that any hidden charts are displayed in the worksheet by putting the eye icons back in their check boxes.
Next, click the chart to select it in the worksheet and then choose File→Print or press Ctrl+P to open the Print screen in Backstage view, where you see the chart now displayed in the print preview area.
If you need to change the printed chart size or the orientation of the printing, click the Page Setup link on the Print screen in the Backstage view or click the Page Setup Dialog Box launcher on the Page Layout tab of the Ribbon. To change the orientation of the printing, change the appropriate options on the Page tab in the Page Setup dialog box.
To change the print quality or print a color chart in black and white, click the Chart tab and change these options. You can return to the print preview area in the Print screen in Backstage view by clicking the Print Preview button at the bottom of the Page Setup dialog box. If everything looks good in the print preview area, start printing the chart by clicking the Print button.