Excel chart print preview different

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 dont miss any worksheets, we are going to review the worksheets in the order they appear in the tabs.

Data file: Continue with CH4 Charting.

The firstworksheet, Closing Prices, is a chart sheet. This means that it doesnot contain any data; remember that chart sheetsjust contain charts. We still need to review it in Print Preview.

1. Click on theClosing Pricesworksheet 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.

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

1. Click on theStock Trendworksheet tab.
2. Go to Print Preview by clicking Print in Backstage View.
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 thirdpages.
   • 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 has a column of seemingly random numbers.
5. Exit Backstage View.

The first thing we are going to do is remove the numbers that are appearing on page 7. To do this, we willhidethe column where they are being stored. We are going to hide the column, instead of deleting the numbers, in case the numbersare being utilized somewhere else in the workbook.

1. Scroll to the right on the worksheet until you find the numbers in column AH.
2. Click anywhere in column AH.
3. On the Home ribbon, click the Format button in the Cells group.
4. In the Visibility section, selectHide & Unhide then selectHide Columns [seeFigure 4.64].
5. The visible column headings should now go from AG to AI.
6. Return to Print Preview in Backstage View to see the changes to the printed worksheet.
7. Notice that there are now five pages. The data and charts are still splitting across multiple pages, but the numbers in column AH are no longer going to print.
8. Remain in Backstage View for the next steps.

Figure 4.64 Hide Columns in Format Menu

The data is still split between pages 2 and 3, and the charts are splitting oddly as well. The first step we will try to fix these issues is to change the page orientation and scaling.

1. While still in Backstage View, change the page orientation to Landscape [use the Orientation drop-down menu in the Settings section].
2. This puts all of the data on one sheet, but the charts are still split between multiple pages.
3. Change thepage scaling to Fit Sheet on One Page [use the Scaling drop-down menu in the Settings section].
4. This fits everything on one page, but it is too small to be able to read.
5. Change the page scaling back to No Scaling.

The next thing we will try is moving one, or both, of the charts. In order to move the charts, we need to exit out of Backstage View.

1. Exit Backstage View.
2. Switch to the View ribbon and then select Page Break Preview. Your screen should look similar toFigure 4.65. [Remember that the dotted blue lines indicate automatic page breaks.]
3. Move the 24 Month Comparison [double-line] chart closer to the top of its page.
4. Move the May 2014-2015 Trend for NASDAQ Sales Volume [line chart] so that it is under the 24 Month Comparison chart.
5. The link to the data source is still at the bottom of page 2 [in A50:A51] so you need to move it as well. Using your preferred method, move the text from A50:A51 to M31:M32.
6. Now your screen should look similar toFigure 4.66.

Figure 4.65 Page Break Preview before moving the charts in Step 3Figure 4.66 Page Break Preview after moving the charts and text

We dont want the data source link text to print on its own page, but there is no room to move it onto the same page as the charts. To fix this, we are going to remove the automatic page break between the charts and the text in M31:M32.

1. Place your pointer on the horizontal blue dashed line [automatic page break] between the line chart and the Data Source link text.
2. When your pointer changes to the double arrow [pointing up and down], drag the page break down into the gray area. This removes the page break.
3. If your vertical automatic page break between columns L and M moves, drag it back between columns L and M.This will make it a solid blue line, which will no longer adjust automatically.
4. Your screen should now look likeFigure 4.67.

Figure 4.67 Page Break Preview after removing a page break

Now you need to do one final check of this worksheet in Print Preview.

1. Go to Print Preview and look at both pages. Page 1 should contain just the data and page 2 should have both charts and the Data Source link text.
2. Exit Backstage View and save the file.

There are four remaining worksheets to be reviewed. Some of them will need minor changesand some will not need any changes. You will need to preview each one and then make the specified changes. In the following steps you will preview and modify the next threeworksheets.

1. All Excel Classes this is a chart sheet, so it should not need any changes.
2. Grade Distribution the chart is splitacross two pages. Fix this by changing the orientation [Landscape] and scaling [Fit Sheet on One Page].
3. Enrollment by Race Chart this is a chart sheet, so it should not need any changes.

Sometimes you might have a worksheet that has data and a chart, but you only want the chart to print. That is the case with the Enrollment Statisticsworksheet.

1. Switch to the EnrollmentStatisticsworksheet.
2. Select the chart.
3. Go to Print Preview. Only the chart is printing. [If it shows the data printing along with the chart, exit Backstage View and be sure to select just the chart on the worksheet.]
4. If needed, change the orientation to Landscape. This orientation looks better when printing just a chart.
5. Exit Backstage View.

You have actually decided that you do not want the Enrollment by Race Chartsheet to be visible at all, but you do not want to delete it. We are going to hide it from anyone looking at the workbook.

1. Right-click on theEnrollment by Race Charttab.
2. SelectHide from the menu that appears. The Enrollment by Race Chartsheet should no longer be visible.
3. Now you want to bring the worksheet back. To unhide it, right-click on any other worksheet tab and select Unhide from the menu. A list of hidden worksheets will be displayed. Select the Enrollment by Race Chartand click OK.
4. Save the CH4 Chartingworkbook.
5. Compare your work [on all of the worksheets] with the self-check answer key [found in the Course Files link].
6. Submitall three files from this chapter[CH4 Charting.xlsx, CH4 Diversity in Enrollment in Community Colleges.docx, andCH4 Diversity in Enrollment in Community Colleges.pptx]as directed by your instructor.

4.4 Preparing to Print by Julie Romey, Portland Community College is licensed under CC BY 4.0