In this section, we will take a look at each of the worksheets created in the previous sections. Since these worksheets contain a combination of data and charts, there are specific things to watch for if you will be printing the sheets.

We will start by looking at each worksheet in Print Preview in Backstage View.  We will then make any changes necessary, such as changing the orientation and scaling or moving charts around on the worksheet.  To make sure we don’t miss any worksheets, we are going to review the worksheets in the order they appear in the tabs.

Previewing Chart Sheets for Printing

Data file: Continue with CH4 Charting.

The All Excel Classes is a chart sheet. This means that it does not contain any data; remember that chart sheets just contain charts.  We still need to review it in Print Preview.

1. Click on the All Excel Classes worksheet tab.
2. Go to Print Preview by clicking Print in Backstage View.
3. Notice that the chart will print on the entire page, in Landscape orientation.
4. There is nothing to change. Exit Backstage View.

Printing Worksheets with Data and Charts

The Stock Trend worksheet has a lot of data and multiple embedded charts.  We need to print the data and the charts, which will require modifications to the page setup.

 1.  Click on the Stock Trend worksheet tab.

 2.  Go to Print Preview by clicking Print in Backstage View.

Mac Users choose “File/Print…” from the Excel File menu option.

3.  Notice that this worksheet is currently printing on seven pages.

4.  As you click through each page you should make the following observations:

• • • The data is split between the first and third pages.
    • The line chart starts on the first page, but part of it is also on the second page.
    • The double-line chart starts on the third page and then finishes on the fifth page.
    • The fourth and sixth pages are blank.
    • The last page (page 7) has a column of seemingly random numbers.

 5.  Exit Backstage View.

6.  The first thing we are going to do is hide the numbers that are appearing on page 7.  We are going to hide the column, instead of deleting the numbers, in case the numbers are being utilized somewhere else in the workbook.

7.  Scroll to the right on the worksheet until you find the numbers in column AH.

8.  Click anywhere in column AH.

9.  On the Home ribbon, click the Format button in the Cells group.

10.  In the Visibility section, select Hide & Unhide then select Hide Columns.

Mac Users: the only way to print a Chart separately is to click on the chart you want to print move it to a new sheet by clicking on the chart, click the Move Chart button on the Chart Design tab, click New Sheet then choose File/Print from the Excel menu and switch to Landscape Orientation if necessary.