Microsoft Office Tutorials and References
In Depth Information
Click the Go Back button to exit the Backstage view and then, on the ribbon, click
the Page Layout tab to display your worksheet in Normal view.
In the Page Setup group, click Print Area , and then click Clear Print Area to remove
the print areas defined for the JanFeb worksheet.
CLEAN UP Close the HourlyPickups workbook, saving your changes if you want to.
With charts, which are graphic representations of your Excel data, you can communicate
lots of information by using a single picture. Depending on your data and the type of chart
you make, you can show trends across time, indicate the revenue share for various
departments in a company for a month, or project future sales by using trendline analysis. After
you create a chart, you can print it to include in a report or use in a presentation.
If you embed a chart in a worksheet, however, the chart might obscure some of your data
unless you move the chart elsewhere on the worksheet. That’s one way to handle printing a
chart or the underlying worksheet, but there are other ways that don’t involve changing the
layout of your worksheets.
To print a chart without printing any other part of the underlying worksheet, click the
chart, display the Backstage view, and then click Print. In the Settings area of the Print
page, Print Selected Chart will be the only option available. If you click anywhere on the
worksheet outside the chart, the Print What area opens with Print Active Sheets selected,
meaning that the chart and underlying worksheet are printed as they appear on the
screen. When you’re ready to print the chart, click the Print button.
TIP Even if the selected chart is smaller than the worksheet on which it resides, it will be
scaled to print at the full size of the printer’s page.