Standalone Charts Printing

If you're using a standalone chart, your chart always prints out on a separate page, sized to fit the whole page. To print out just the chart page alone (rather than the whole workbook), switch to the chart's worksheet, and then choose Office Button > Print. To print out the entire workbook which prints your data worksheet and chart worksheet on different pages look in the "Print what" section and select the "Entire workbook" option.

Excel automatically sets all chart worksheets to Landscape orientation, which orients the page so that the long edge runs horizontally across the bottom. If this layout isn't what you want, before you print the chart, choose Page Layout > Page Setup > Orientation > Portrait. Remember, if you're still not sure how your printout will look, you can always use the handy Page Layout View to see a sneak preview.