Build a histogram

Show how often measurements fall within each interval.

Guides · Charts · 4 min read

Example: packing times

The example records 90 orders from three packing zones. Packing time is in seconds; item count and parcel mass describe each order.

Download the example data (CSV)

This is the same example used in Help. The CSV contains the observations to import.

1. Create the analysis

In the sidebar, open Plots and create an analysis. Name it, select New blank worksheet, then choose Create analysis.

2. Import the data

On Worksheet, choose Import. Select the downloaded CSV or paste its contents. Set the delimiter to Comma, use Decimal dot, and check First row contains column names. Preview the import, then choose Import into worksheet.

3. Assign the input columns

On Inputs, choose Histogram in Chart type. In Data arrangement, choose Single variable — no grouping.

Open the column picker for Measurement and select packing_time_s. It contains one packing time per order, in seconds.

4. Set the chart options

In Statistics, set Bins to Automatic, Y-axis meaning to Frequency and Distribution overlay to None. Leave Specification limits unchecked.

Open Labels and enter Explore the distribution of packing times in Chart title. Leave Horizontal axis label and Vertical axis label blank so the source labels are used.

Plots: Inputs with the example’s assignments and settings
Histogram Inputs with the example’s column assignments, chart options and title. View full-size image (opens in a new tab)

5. Create chart

Choose Create chart, then open Results. Check Data used before comparing the chart with this guide. All stored worksheet rows participate; sorting or filtering the worksheet does not change the analytical sample.

6. Interpret results

  1. Read the bars

    Packing time is on the horizontal axis in seconds. Each bar counts orders whose times fall in that interval. Taller bars mean more orders, not longer individual orders.

    Explore the distribution of packing times
    Packing times for all 90 orders, counted in automatically chosen 20-second intervals. View full-size chart (opens in a new tab)
  2. Find the busiest interval

    The automatic bins are 20 seconds wide. The 140–160 second interval has the most orders: 15 of the 90. The shortest recorded time is 59.9 seconds and the longest is 252.5 seconds.

  3. Keep the groups in mind

    These bars pool three packing zones. The shape combines their different orders and workloads. Changing the bins can change the appearance without changing any measurements.

  4. Choose the next comparison

    Use the packing-zone box-plot guide to compare zones. Before changing staffing, compare orders with similar item counts and inspect the full bins and data summary. This pooled histogram does not explain why an order took longer.

More details: read each result section

Complete result tables use six significant digits, as in Help.

Data used

Worksheet rows is 90; Eligible observations across series is 90; Excluded observations is 0. All source rows are used. Check these counts and keep the example’s column assignments when comparing runs. Worksheet sorting and filters do not change the analytical sample.

All stored rows are considered in original order. Worksheet sorting and filters do not change the analytical sample.

Data used · 1 row
Worksheet rowsEligible observations across seriesExcluded observations
90900

Data summary

Series names the measurement or group. Valid and Missing give counts; Mean and Median describe the center. Sample SD describes spread. Minimum and Maximum are the observed ends; Q1 and Q3 enclose the middle half. These summaries describe the captured observations, not acceptance limits.

Data summary · 1 row
SeriesValidMissingMeanSample SDMinimumQ1MedianQ3Maximum
packing_time_s900150.57245.242559.9115.125152.9184.675252.5

Histogram bins

Read every interval’s Lower edge, Upper edge and Count. In this frequency chart, frequency is the bar height and equals Count. The 11 counts sum to 90. Automatic binning selected 20-second intervals for this example.

Histogram bins · 11 rows
SeriesLower edgeUpper edgeCountfrequency
packing_time_s406011
packing_time_s608044
packing_time_s8010088
packing_time_s1001201414
packing_time_s1201401010
packing_time_s1401601515
packing_time_s1601801111
packing_time_s1802001212
packing_time_s2002201010
packing_time_s22024044
packing_time_s24026011

7. Create a report

Keep the native chart and Data used, together with Data summary, Histogram bins. Record the column assignments and chart options. Include the study context and any checks of unusual observations. Keep the chart’s units and the limitations described in the walkthrough.

Choose Add to report from the completed run. Open Choose individual items and advanced options to select tables and charts, then choose Add to draft. Hidden items stay in the saved analysis.

Name the report and add the purpose of the study and your interpretation. Choose Save, review Preview, then use Export → Download HTML. The example below contains the full selected content, including results beyond one screen.

Complete native output for this Help example, including applicable tables, charts and run notes. Report numbers use the app’s displayed precision. Exported charts are static. On narrow screens, scroll wide charts and tables sideways.
View example report: Histogram — Explore the distribution of packing times

We use Microsoft Clarity to understand how visitors use this website, including session recordings and heatmaps. You can use the website without accepting analytics.

Your choice is saved in this browser for six months. Privacy notice

Current choice: Not chosen.