Include Top

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. Histogram Options

  6. 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).

  7. Histogram Chart Options

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

  9. Histogram

  10. 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).

Define, Measure, Analyze, Improve, Control

Lean Six Sigma Software Excel Add-in

Simulate, Optimize,

Lean Six Sigma Software Excel Add-in

Web Demos

Our CTO and Co-Founder, John Noguera, regularly hosts free Web Demos featuring SigmaXL and DiscoverSim
Click here to view some now!

Contact Us

Ph: 1.888.SigmaXL (744.6295)