How to Create a Distribution Chart

A variety of distribution charts can be created in Microsoft Excel, such as the Normal Distribution chart. The data and series can be expressed using line graphs, bar graphs, pie charts and many others, including three-dimensional displays. Once you have created the chart to your liking, try experimenting with the vast array of colors to make your chart even more striking. What's more, the chart you create or series of charts can be easily exported to Microsoft Word and many other applications to integrate with the main content.

Things You'll Need

  • Microsoft Excel (version 2010 or 2007)
Show More

Instructions

    • 1

      Open Microsoft Excel.

    • 2

      Type the number 3.0 in the A1 cell and then type the number 2.75 in the A2 cell just below it. Highlight both cells.

    • 3

      Drag the bottom-right of the selected cells to the 25th row. Use the tiny black square as a handle. Each number will be decremented by .25, giving the successive number below it.

    • 4

      Select cell B1and enter the equation as: "=normdist (a1,0,1,0)" and hit the "Enter" key. The Normal Distribution for the number (3) in cell A1 with a mean of zero and a Standard Deviation of 1 appears in the B1 cell.

    • 5

      Click the bottom-right of the B1 cell and drag the cursor to the 25th cell as you did in step 3. The Normal Distribution appears in each corresponding B cell for its "A" cell number. Keep the cells from B1 to B 25 selected.

    • 6

      Click "Insert" from the main menu and then select "Line" and choose the first line graph from the 2D sub-selection. The chart for the Normal Distribution appears a bell-shaped line graph.

    • 7

      Select "Column" from the main menu and choose the first column graph in the 2D sub-selection. The chart now is represented as a column graph. Experiment accordingly with each variation and ultimately decide which style best suits your presentation.

Learnify Hub © www.0685.com All Rights Reserved