Thursday, September 27, 2012

How to Create a Histogram in PowerPoint


1. Arrange your data into columns on paper to organize yourself before creating a histogram in PowerPoint. For example, list input data in one column and the range in the second column. Identify the frequency of the data occurring within each of the ranges of the second column.
2. Open PowerPoint to create a new presentation so you can build your chart based on the information you've organized on paper. Right-click on the slide. Choose the 'Layout' option. Click the 'Title and Content' layout. Click the 'Click to add title' text box, and type 'Histogram.'
3. Click the 'Insert Chart' button. Choose the first 'Clustered Column' option. Click 'OK.' Because you will show only two columns of information, drag the right corner of the range so it ends at Column B. Press the 'Ctrl' and 'A' keys and then press the 'Delete' key to delete the default data and add your own. For example, in column A, enter the following data:Range60802040
4. In column B, enter the following data:Frequency3321
5. Click the 'Microsoft Office' button in the Excel window, and click the 'Close' option to return to the PowerPoint window.
6. Add a text box to list the percentage legend to the right of your column chart. From the 'Insert' menu, click the 'Text Box' information and enter this text:100%80%60%40%20%0%
7. Add a cumulative percentage point line. For example, under the 'Insert' menu, choose the 'Shapes' option and select a line. Draw a line from each column to the next column to show the increasing cumulative percentage for the bin range. Insert a text box to label the percentage complete. For example, on the 60 value column, 30% of the data is represented. On the 80 value column, 60% of the data is represented. On the 20 value column, 80% of the data is represented. On the 40 value column, 100% of the data is represented.

Blogger news