Create a Basic Histogram in Excel Using SigmaXL

How to Create a Basic Histogram in Excel Using SigmaXL

Single (Basic) Histogram

SigmaXL makes it easy to create a professional frequency distribution histogram directly inside Microsoft Excel. Whether you are working on a Six Sigma project, statistical process control analysis, or visualizing customer survey data, the Basic Histogram tool provides flexible bin width controls, normal curve overlay, and instant chart generation without leaving your spreadsheet.

1. Click Sheet 1 Tab of Customer Data.xlsx (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.