Microsoft Office Tutorials and References
In Depth Information
14. On the ribbon, click the Page Layout tab.
Excel displays your worksheet in Normal view.
15. In the Page Setup group, click Print Area , and then click Clear Print Area .
Excel removes the print areas defined for the JanFeb worksheet.
CLEAN UP Save the HourlyPickups workbook, and then close it.
With charts, which are graphic representations of your Excel data, you can communicate
lots of information with 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 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 will probably obscure some of
your data unless you move the chart to a second page in 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, click the chart, click the File tab, and then click Print to display the Print
page in the Backstage view. In the Settings area, 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 the Print Active Sheets option 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.
In this exercise, you’ll print a chart.
SET UP You need the CorporateRevenue_start workbook located in your Chapter11
practice file folder to complete this exercise. Open the CorporateRevenue_start
workbook, and save it as CorporateRevenue . Then follow the steps.
1. Select the chart.
2. Click the File tab, and then click Print .
The Print page of the Backstage view is displayed.