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. /bar-graph-column-chart-in-excel-3123560-3-5bf096ea46e0fb00260b97dc.jpg "how to insert a header in excel using a chart")
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. Type "Put my Excel chart here" (or something like that). (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 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. To compare large numbers of time-independent data points. To visualize outliers, clusters, non-linear trends, and linear trends in a large set of data. To explore positive or negative trends in the variables. The appearance of the X and Y chart will be quite similar to a diagonal arrangement. To analyze if there is any correlation between two sets of quantifiable values. In the following scenarios, you should use a scatter plot instead of a line graph: In Excel, you can create a scatter plot graph to visualize and compare numeric values obtained from scientific and statistical analyses. The horizontal (X) axis represents one set of numerical data, and the vertical (Y) axis indicates another data set.īut, the Excel line graph visualizes all category data on the horizontal (X) axis and numerical values on the vertical (Y) axis. Both are similar except for the data representation along the horizontal (X) axis.Ī scatter chart consists of two value axes for quantitative data visualization. In Microsoft Excel, you may confuse whether an X-Y graph is a scatter plot or a line graph. Scatter Plot Excel-When You Should Use It Keep reading this data-based article to learn how. However, you may be wondering how to make a scatter plot in Excel. When you need to visualize the relationship between two sets of quantitative data, Microsoft Excel makes it possible for you to create an X-Y scatter graph.įor regression analysis, scatter plot graphs are the most important data visualization tool.
0 kommentar(er)
