You can, of course, use the «Sorting» tool, but then the general idea of the seasonality of the firm's activity is lost. For example, pay attention to the picture:Īccording to the table, you do not immediately to notice in what month the company's revenues were the highest, and in what the smallest ones. How not to create a table, its data will be less readable than the graphical representation in diagrams and charts. To do this, make a double-click on the title with the left mouse button and enter the text as shown in the picture:Īfter you sign a new title, click on any cell to deactivate the chart settings and go to normal mode. From the group of different chart types, select the «Doughnut». Select «INSERT» – «Insert Pie or Doughnut».Select the A1:B4 range in the source table.Now we are constructing the diagram according to the data of the Excel table, which must be signed with the title: Identify which shape best describes the graph from Part 1: Skewed Right Skewed Left Normal Uniform 3.How to build a chart on the table in Excel? Why were there no ages younger than 18 years? 2. 15) Type your answers to the follow-up Questions at the end of your Excel document after finishing Parts 1-111 16) Save your graph and data.ġ6) Save your graph and data. The graph may also be resized, moved, or copied to another place in your spreadsheet or into a word processing document. For example, you can change the bar color by double clicking on a bar and selecting a new color from the pop-up menu. Type: Number of Adults Arrested 14) At this point, the graph may be enhanced by clicking on any part of the graph and using the pop-up menus to change its characteristics. Click on "Axis titles" and in the text area beside Category X." Type: Age (years) 13) Click the mouse in the text area beside "Value Y. Once the cursor is positioned in the text box, type: Number of Adult Arrests by Age Group - Washington County 12) Next, you need to add titles to your X- and y-axes. Add a title to your chart by clicking the mouse button in the text area beside Chart title. At the top left of the menu, click on the tab that says "Add Chart Elements. Select a basic histogram, no gaps between the jars. 11) Sample graphs should appear on the screen. On pop-up menu you will see sub-type charts. 10) On the pop-up menu, click on the top choice, "Column".
On the right-hand side position the cursor over the icon entitled "Chart." Depress the left mouse key and drag the icon to the tool bar at the top of the screen. 90) Select "Insert on the left-hand side of the menu. 9B) Select "Customize" and then select the "Commands' tab on the top of the pop-up menu.
Note: If the Chart Wizard icon is not on the toolbar, follow these steps: 9A) Click on the Tools menu at the top of the screen. Release the mouse and the cells should remain highlighted.ĩ) While the cells are still highlighted, click the "Insert" tab and then a histogram on the "Chart" button. 8) Place the cursor in cell A1, depress the left mouse key and while holding it down, drag the mouse to cell B7. In cell A1, type: Age Group In cell B1, type: Frequency 3) ) ) 4) 5) In cell A2, type the class limits of your first age group, such as 18-23 ) 6) In cell B2, type the corresponding frequency 7) Moving down one row at a time, repeat Steps 4 and 5 to enter the remaining class limits and corresponding frequencies. Class Umits Tally 2) Frequency 10 18-23 To invoke Excel, click on the Excel icon on the screen. Use 18 as the lower class limit for the first class. 28 Age Sex 18 M 25 F 32 м 29 M 19 M 22 M 36 M 34 F 18 M 27 M 48 M 22 M 30 F 18 M M Age Sex 52 M 33 F 41 M 20 M 22 M 31 M 19 F 21 M 27 M 31 M 29 M 27 F 40 M 32 M 24 M a 1) Create a frequency distribution of the ages (men and women combined) with 6 classes. Part I: Creating a Frequency Distribution and Histogram The following data represent the sex and age of individuals arrested in Washington County on January 7". No prior knowledge of Excel is necessary. Excel is then used to create a histogram and pie chart representation of the data. Transcribed image text: Excel Activity #1: Creating a Bar Graph and Pie Chart Description: This lesson begins by having the students review the process of creating a frequency distribution for a sample of ages of people arrested in Washington County.