Place your pointer on the horizontal blue dashed line (automatic page break) between the line chart and the Data Source link text.To fix this, we are going to remove the automatic page break between the charts and the text in M31:M32. We don’t 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. Now your screen should look similar to Figure 4.30. Using your preferred method, move the text from A50:A51 to M31:M32. 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.Move the May 2014-2015 Trend for NASDAQ Sales Volume (line chart) so that it is under the 24 Month Comparison chart.Move the 24 Month Comparison (double-line) chart closer to the top of its page.(Remember that the dotted blue lines indicate automatic page breaks.) Your screen should look similar to Figure 4.30. Switch to the View ribbon and then select Page Break Preview.In order to move the charts, we need to exit out of Backstage View. The next thing we will try is moving one, or both, of the charts. Mac Users: uncheck the Scale to Fit option Change the page scaling back to No Scaling.This fits everything on one page, but it is too small to be able to read.Change the page scaling to Fit Sheet on One Page (use the Scaling drop-down menu in the Settings section).This puts all of the data on one sheet, but the charts are still split between multiple pages.Mac Users click the Landscape Orientation button While still in Backstage View, change the page orientation to Landscape (use the Orientation drop-down menu in the Settings section).The first step we will try to fix these issues is to change the page orientation and scaling. The data is still split between pages 2 and 3, and the charts are splitting oddly as well. Remain in Backstage View for the next steps.The data and charts are still splitting across multiple pages, but the numbers in column AH are no longer going to print. Return to Print Preview in Backstage View to see the changes to the printed worksheet.The visible column headings should now go from AG to AI.In the Visibility section, select Hide & Unhide then select Hide Columns.On the Home ribbon, click the Format button in the Cells group.Scroll to the right on the worksheet until you find the numbers in column AH.We are going to hide the column, instead of deleting the numbers, in case the numbers are being utilized somewhere else in the workbook. The first thing we are going to do is hide the numbers that are appearing on page 7.The last page (page 7) has a column of seemingly random numbers.The double-line chart starts on the third page and then finishes on the fifth page.The line chart starts on the first page, but part of it is also on the second page.The data is split between the first and third pages.As you click through each page you should make the following observations:.

Notice that this worksheet is currently printing on seven pages.

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

Go to Print Preview by clicking Print in Backstage View.

Click on the Stock Trend worksheet tab.

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

Excel for mac backstage view