Inserting the Excel chart or worksheet range Paste the chart or worksheet range as a picture You should be able to see your portrait pages, your landscape page and your remaining portrait pages. In Word 2007 or Word 2010, do Page Layout > Orientation > Landscape.On the Margins tab, click Landscape and then click OK. In Word 2003 or earlier versions, do File > Page Setup.(And the Status bar at the bottom of the screen will say "Sec 2" or "Section: 2".) Click in the text that says "Put my Excel chart here".To make Section 2 landscape, follow these steps: (You will see that the Status bar at the bottom of the screen now says "Sec 3" or "Section: 3" to let you know that you're in Section 3.) In Word 2007 and Word 2010, Page Layout > Page Setup > Breaks > Next Page. To do that, in Word 2003 or earlier versions, Insert > Break. Now, create the section break to mark the end of section 2.Click at the beginning of the text you want after the landscape page chart, so the screen looks like Figure 2 (you'll have to imagine the insertion point flashing on and off!).įigure 2: Click at the beginning of the text you want to appear after the landscape page.
![how to insert a header in excel using a chart how to insert a header in excel using a chart](https://www.excel-easy.com/examples/images/headers-footers/code-header.png)
Type "Put my Excel chart here" (or something like that).
![how to insert a header in excel using a chart how to insert a header in excel using a chart](https://www.howtogeek.com/wp-content/uploads/2020/09/insert.png)
(In Word 2007 or Word 2010, if you don't see "Section: 2", right-click the status bar and click the Section option.) You will see that the Status bar at the bottom of the screen now says "Sec 2" or "Section: 2" to let you know that you're in Section 2. In Word 2007 or Word 2010, on the Page Layout tab, in the Page Setup group, click Breaks, and then click Next Page. In Word 2003 and earlier versions, do Insert > Break.(That is, the empty paragraph shown in Figure 1.) Click in the empty paragraph where you want the landscape page to start.Section 2: Landscape (for the Excel chart or worksheet range) We want to end up with: Section 1: Portrait
![how to insert a header in excel using a chart how to insert a header in excel using a chart](http://www.wikihow.com/images/b/be/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-14-Version-2.jpg)
We are starting with a plain document containing several portrait pages. And you need to make that Section landscape. To put a landscape page in the middle of some portrait pages, you need a new Section. Now we can create the landscape page (and we will later insert the Excel chart or worksheet range into that page). That is, arrange your text so there is one empty paragraph where you want the landscape page to start.įigure 1: Arrange your text so you have one empty paragraph where you want the landscape page. Get your text organizedĪrrange your text so it looks like the text in Figure 1. If you don't like working while seeing ¶ signs, click the same button again at the end of the game to turn them off. That will display a ¶ sign for the end of every paragraph. So click the button that looks like ¶ (in Word 2007 and Word 2010 it's on the Home tab). To insert a chart or range of a worksheet without going crazy, you have to be able to see what's going on. Get organized before you begin Make sure you can see what's going on In the middle of your document, you need just one or two pages in landscape, to contain a chart or range of a worksheet from Excel. Here's the problem: you have a Word document containing several pages, all in portrait orientation. Insert your Excel chart or selected range as a Picture.Create a new section and make it landscape.You can also enter descriptive text by simply typing it.To display the sheet name, click Sheet Name in the same group.
#How to insert a header in excel using a chart code#
Excel will display the &Picture code until you move to another section of the header. Locate the picture file and click Insert.
![how to insert a header in excel using a chart how to insert a header in excel using a chart](https://www.smartsheet.com/sites/default/files/ic-excel-pie-charts-add-data-labels-options-chosen-final.png)
In Excel 2003, choose Header and Footer from the View menu. To do so, click the Page Layout button in the bottom-right corner to switch to Page Layout view.