How to construct a histogram
in EXCEL 2007?
Step
1: Click on A above the first row to select all the data in the first column.
Step
2: Click on Add-Ins on the Toolbar.
Step
3: Click on DDXL.
Step
4: Select Charts
and Plots and then select Histogram
from the Function type.
Step
5: Select the variable (Weight in our example) on the Names
and Columns field on the right-hand
side.
Step
6: Drag the variable (Weight in our
example) on the Names and Columns field to the Quantitative Variable field on the left-hand side.
Step 7:
Click the OK Button.