![]() ![]() Step 6: Click on the cell icon to the right of “Input Data.One of the mysteries of modern life is the order in which series appear in the legend of an Excel chart. Step 5: Click on “Histogram” and then click on “OK.” See this how to on how to load the Microsoft Excel Data Analysis ToolPak for instructions. ![]() Step 4: Click on the “Data” tab and then choose “Data Analysis.” If you don’t have the Data Analysis button, you need to add the ToolPak (it only takes a few seconds). If you’re not sure how to calculate these values, see this article on how to create a frequency distribution table. Step 3: Enter the rest of the minimum data values for your bins into the same column from Step 2. In our example, we put the values in column A, so we need to put 118 (the lowest value) into cell B2. Step 2: Enter your lowest value into the second cell of the next column. Step 1: Enter your data into a single column. How to Create a Histogram in Excel 2007/2010: Steps How to Create a Histogram in Excel 2007/2010: Overview ![]() Select “Format Chart Area” and click the down arrow next to “Chart Options.” Select “Series Frequency.” Click the Three Bars to the right (Series Options.” Use the slider to make the gap width zero. To correct this, right click just outside the chart area (but within the chart window). Tip: Histograms traditionally do not have gaps between the bars. ![]() Step 10: Click “OK” and Excel will create the histogram. If you don’t check this, you’ll only get a frequency chart (a list), not the actual histogram. For example, click the “New Worksheet” button. Step 8: Click an option for where you want your data to appear. For example, type “B2:B4” into the box to indicate your BINS are in cells B2 to B4. Step 7: Type the location of your BINS into the “Bin Range” box. For example, if your data is in cells A2 to A10 then type A2:A10 into the box. Step 6: Type the location of your data into the Input Range Box. Step 5: Highlight “Histogram” and then click “OK.” Step 4: Click the “Data” tab, then click the “Data Analysis” button. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |