How Do I Create a Basic Histogram in Excel Using SigmaXL?

Single (Basic) Histogram

1. Click Sheet 1 Tab of Customer Data.xls (or press F4 to activate last worksheet).
2. Click SigmaXL > Graphical Tools > Basic Histogram.
3. Ensure that entire data table is selected. If not, check Use Entire Data Table. Click Next.
4. Select Overall Satisfaction, click Numeric Data Variable (Y) >> as shown:



5. Click Next. Ensure that Normal Curve is checked. Set Start Point = 1. Change the Bin Width to 0.5, and the Number of Bins to 8. Click Update Chart to view the histogram. (If the survey satisfaction data was pure integer format we would have checked the Integer Data option).




6. Click Finish. A histogram of Overall Customer Satisfaction is produced.




7. Note that bin one is 1 to < 1.5, bin 2 is 1.5 to < 2, etc.

Tip: Any graph produced by SigmaXL can be Copied/Pasted into Word. It can also be enlarged by clicking on the graph and dragging the corner. The number of decimal places displayed can be modified by clicking on the Axis Label and selecting the Number tab to adjust. The text label alignment can also be modified by selecting the Alignment tab (Excel 2007/2010: Select Axis, Right Click, Format Axis…).


Click here to download a Free 30-Day Trial.