Manpower Histogram in Excel: Build a Staffing Chart

Charts & pivot tables · Updated November 21, 2026

A manpower histogram in Excel is a time-based chart showing how many people—or how much labor capacity—you need during each day, week, or month. Build one by listing each assignment’s start date, finish date, and staffing amount, calculating the active manpower for each date, then plotting those totals as columns.

What a manpower histogram shows

Project managers use a manpower histogram to see how staffing demand changes over time. The horizontal axis represents time; the vertical axis represents a quantity such as workers, full-time equivalents (FTEs), or labor hours per period. A high column signals a peak in demand, while a low or empty column indicates lighter staffing or no scheduled work.

The chart is useful for planning and communication, but it is only as meaningful as its units and assumptions. A total of 12 workers is not the same thing as 12 FTEs if some people are assigned part-time. Likewise, a headcount chart does not show whether the workers have the right trades or skills. A single total can conceal a shortage of electricians alongside a surplus of other staff.

“Manpower” is common in construction and project scheduling, although “workforce” or “staffing histogram” may be preferred in some workplaces. The spreadsheet method is the same: define the quantity being counted, define the time interval, and make the source assignments consistent.

Choose the measure and time interval

Before entering data, decide what each bar should mean. For a simple headcount, use one unit for each person assigned full-time. For a mixed or part-time workforce, use FTE allocation values: for example, 0.5 for half-time and 1.0 for full-time. You can also track labor hours, but that requires hours per period rather than merely counting active assignments.

  • Daily: useful when work changes quickly or short assignments matter; it can create a crowded chart for a long project.
  • Weekly: a practical planning view for many projects, provided the selected date represents the week consistently.
  • Monthly: useful for broad capacity planning, but can hide short peaks and gaps.

A weekly snapshot taken every Monday answers “How much staff is active on Monday?” It does not calculate the average or peak for the entire week. If the purpose is weekly average staffing, sum the daily FTE values for the week and divide by the number of days, or calculate total labor hours and divide by the standard hours in a workweek. State which interpretation the chart uses so readers do not confuse a snapshot with a period average.

Set up the source data

In Excel for Microsoft 365 on Windows, create a structured list with one row per person-assignment or other unit you intend to count. For a basic FTE histogram, use columns like these:

  • A: Person, role, or assignment name
  • B: Start date
  • C: Finish date
  • D: FTE allocation, such as 1 or 0.5

Enter actual Excel dates, not text that only looks like a date. A task beginning May 4 and finishing May 15 should have those dates in the start and finish columns. If the finish date counts as an active workday, keep that convention consistently. Put the dates you want to chart across row 1, starting in F1, and label the row above or nearby with the chosen measure, such as “FTEs active on date.”

For larger or changing schedules, select the source data and use Insert > Table. A table makes it easier to filter, extend, and maintain the assignment list. Give the columns clear names, avoid blank rows inside the list, and check that each assignment has a valid start date, finish date, and allocation. If work is intermittent, represent the separate periods as separate assignment rows rather than treating the person as continuously active between distant dates.

Calculate manpower for each date

With start dates in B2:B5, finish dates in C2:C5, FTE allocations in D2:D5, and a real timeline date in F1, enter the following in F2. It adds the allocation for rows whose start date is on or before the timeline date and whose finish date is on or after it:

=SUMIFS($D$2:$D$5,$B$2:$B$5,"<="&F$1,$C$2:$C$5,">="&F$1)

For example, suppose the four assignments are Alpha (May 4–15, 1.0 FTE), Bravo (May 6–8, 1.0), Charlie (May 4–8, 0.5), and Delta (May 11–22, 1.0). If F1 contains May 11, Alpha and Delta are active, while Bravo and Charlie have finished. The formula returns 2.0 FTEs. The date ranges in this example are inclusive, so a person remains counted on the listed finish date.

Copy F2 across the timeline. The dollar signs keep the assignment ranges fixed, while F$1 changes to G$1, H$1, and so on. If your list extends beyond row 5, adjust every source range to cover the actual records, or use a table-based formula. For a straightforward headcount, enter 1 for each full-time person; the resulting total is then a count of active assignment rows. Make sure the timeline cells contain dates, not labels such as “Week 1,” because the comparison depends on Excel date values.

Build and format the chart

Once the dates and totals are ready, select the timeline dates and their calculated values. In Excel for Microsoft 365 on Windows, choose Insert > Insert Column or Bar Chart > Clustered Column. A column chart is the usual choice because each bar represents a discrete time interval. Add a descriptive chart title, such as “Planned FTEs by Week,” and label the vertical axis if the unit might otherwise be unclear.

Improve readability by using consistent date intervals and sensible axis labels. If the chart includes many daily columns, make it wider, chart fewer dates, or summarize by week. You can format the horizontal axis to show a readable date format, and use a consistent number format for the staffing totals. Avoid a smoothed line or 3-D columns when the purpose is to compare staffing levels by period; those effects can make values harder to judge.

A useful chart often includes a capacity reference, such as a planned maximum of 20 FTEs, but distinguish that reference from actual staffing data. A simple approach is to add a second series containing the same capacity value for every date and format it as a line in a combo chart. If you add this, label it clearly as a limit or capacity target; it is not another workforce count.

Interpret peaks, gaps, and totals

Look for the dates where demand exceeds available capacity, drops unexpectedly, or changes sharply. A peak may point to a resource conflict, a need for temporary staff, or a schedule that could be staggered. A gap may be intentional, or it may reveal a missing assignment or an incorrect date. Compare the chart with the project schedule and the relevant team’s availability before treating a visual spike as a confirmed problem.

Do not add the bars and call the result the number of workers on the project: the same worker can appear in many successive periods. The sum of weekly FTE snapshots is closer to “FTE-weeks” only under an appropriate weekly definition, not a count of unique people. For unique headcount over a whole project, identify distinct people separately. For total labor effort, use period hours or another measure that represents effort, rather than summing snapshots.

Also distinguish planned from actual staffing. A histogram built from planned start and finish dates describes a plan. It does not establish who showed up, how many hours they worked, or whether work was completed. Actuals need dated attendance, time-entry, or other reliable records.

Common data problems and limitations

  • Double-counting people: If the same person has two overlapping assignment rows, a row-based total counts both. Combine their allocation appropriately, or model roles and work separately while making clear that the chart measures assignment load rather than unique people.
  • FTE totals above one for a person: This can be valid if allocations represent concurrent work that exceeds planned capacity, but it may also indicate duplicate records. Check the underlying schedule.
  • Blank or reversed dates: A missing date can exclude a record or make the result misleading. Validate that finish dates are not earlier than start dates and that required fields are complete.
  • Weekends and holidays: The basic formula counts any calendar date inside a range. It does not remove nonworking days. Use a working-day schedule or calculate only the dates that belong to the project calendar if those days should not count.
  • Changing assignments: If allocation changes during a task, split the task into date ranges with different FTE values. A single fixed allocation cannot express a change over time.

There is another important limitation: this formula answers whether an assignment is active on a particular date. It does not prorate a start or finish day, account for shift hours, or infer daily work patterns. If a worker is scheduled only on Tuesdays and Thursdays, model those days or use a more detailed schedule rather than treating the full date range as continuous availability.

Improve the workbook for ongoing use

For a one-off chart, ordinary ranges and a copied formula may be enough. For a workbook that will be updated repeatedly, use an Excel Table for assignment records, apply data validation where helpful, and keep the chart linked to a clearly defined calculation area. Freeze the header row if the source list is long, and use filters to inspect a particular role or team without deleting records.

Consider separate charts or views for different trades, departments, or locations. A project-wide total can be useful for budget or capacity discussions, but it cannot show whether the right specialty is available at the right time. Keep source data, calculations, and presentation distinct: that makes it easier to audit a surprising total and to update the chart without overwriting the assignments.

Excel for the web supports common worksheet formulas and charts, though some ribbon labels or chart-formatting options can differ from the Windows desktop application. On Mac, the workbook logic is the same, but ribbon placement and some dialogs may differ. The formula above uses standard Excel functions and comma argument separators; if your regional settings require semicolons, Excel may display or require a different argument separator.

Frequently Asked Questions

Is a manpower histogram the same as a resource histogram?
They are often used to mean a time-based view of resource demand. “Manpower” usually emphasizes people or labor, while “resource” can include equipment, materials, or other capacity. Confirm the units before comparing charts.

How do I count workers active on a date in Excel?
List each assignment’s start and finish dates, place the date to evaluate in a timeline cell, and sum the allocation for rows active on that date. The SUMIFS example above does this when the ranges and date headers match the stated layout.

Should a manpower histogram show headcount or FTE?
Use headcount when every listed person should count equally and the question is how many people are present. Use FTE when part-time assignments or differing allocations matter. Label the chart so its unit is unmistakable.

Can a weekly histogram show average staffing for the whole week?
A formula evaluated on one date shows staffing on that date, not the weekly average. To show an average, calculate staffing for each day in the week and average those daily values, or calculate total weekly labor hours and convert them to an average FTE using a stated workweek definition.

Why is my histogram higher than the number of people on the team?
Overlapping assignment rows can count one person more than once, and fractional allocations can sum to more than the available capacity. Check duplicate or overlapping records and decide whether the chart is measuring unique people, assignment load, or planned FTE demand.

When a different tool may be better

Excel works well for a transparent, modestly sized schedule that someone can maintain and review. A project scheduling or workforce-planning system may be more suitable when assignments change frequently, calendars and shifts are complex, multiple people edit the plan, or resource conflicts need to be managed across many projects. Those systems may provide more specialized scheduling features, but they still depend on accurate source data and clear definitions of capacity.

For a reliable Excel histogram, keep the model simple enough to audit: define whether the chart measures people, FTE, or hours; use consistent dates and allocations; calculate each interval using the same rule; and label the finished chart. That combination makes the chart useful for spotting staffing patterns without implying more precision than the underlying schedule supports.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.