When an organization faces an expected staffing shortfall, bringing the issue to leadership’s attention is a critical first step. However, a high-level forecast alone rarely tells executives where the gap is actually coming from. When analysts and operational teams are tasked with explaining complex metrics, the temptation is often to squeeze every single detail, data point, and comparative category into a single chart.
That exact communication challenge took center stage during a recent custom client workshop hosted by Storytelling with Data. The participating team faced a multi-faceted dilemma: they needed to demonstrate that full-time equivalent (FTE) staffing levels were expected to fall below the initial corporate plan, highlight that a significant decline in operations support roles was driving a large portion of that trend, and ultimately prompt leadership to initiate a strategic discussion on how to resolve the mounting gap.
While all the crucial information was technically present in their initial reporting, the core narrative was effectively buried beneath layers of visual complexity. The original slide required readers to process multiple variables simultaneously. The tops of stacked bars, trend lines, and an attached data table all attempted to convey overall FTE figures in different ways. Meanwhile, internal segments within the bars displayed a complex breakdown by individual job roles, while plans, actuals, year-to-date averages, and forward-looking projections added yet another interpretive layer.
Although each individual element answered a reasonable operational question, packing them all into a single graph made it exceedingly difficult for leaders to extract clear answers. Recognizing this hurdle, the workshop participants took a step back to evaluate what executives actually needed to navigate the upcoming conversation. They concluded that leadership primarily required answers to two fundamental questions: How large of a shortfall should the organization realistically expect, and what do the latest staffing figures reveal about where the shifts have occurred? Rather than forcing every metric into a single, overcrowded graph, the team decided to separate the narrative into two distinct, focused visuals, with each graphic dedicated to answering a single question.
Utilizing a Line Chart to Clarify the Overall Trend
To tackle the first challenge regarding the anticipated shortfall, the team turned to a standalone line chart. This simplified visual format made it much easier to track how staffing levels had measured up against the official plan established at the start of the year, while also offering a clear comparison for projected figures moving forward.
By stripping away extraneous role-mix breakdowns and data tables, this view created ample visual space to incorporate targeted annotations at key inflection points. As a result, executives could focus entirely on the expected gap to plan without needing to decode complex internal distributions or cross-reference separate tables. The line chart successfully established the macro-level trajectory, setting a clear foundation for the discussion.
Incorporating a Second View for Role-Level Breakdowns
Once the overall trend and expected difference from the annual target were established, the next logical step was to examine role-level changes in the actual data to pinpoint where the largest shifts had occurred. In this context, month-to-month operational fluctuations were less important than the broader trajectory.
To capture this effectively, the team utilized a slopegraph that plotted only the start-of-year figures against the latest actual month. This streamlined approach provided an immediate, uncluttered sense of which specific roles had experienced the most dramatic changes. By employing color and descriptive text very sparingly, the design successfully drew the audience’s attention directly to the notable decline in operations support roles, enabling viewers to immediately grasp the primary driver of the staffing gap.
Together, these two distinct visuals functioned as a cohesive pair. The standalone line chart answered the broader question of what was happening overall, while the slopegraph clarified which specific roles had shifted the most since the beginning of the year.
Strategic Planning for Sharing the Data Narrative
The way these insights were presented depended heavily on the delivery format. For a static summary report that might be read independently or forwarded across departments without a presenter present, the two views could be placed together on a single page. In this layout, a takeaway slide title clearly states the expected shortfall, while brief supporting text points directly to the decline in operations support roles and signals the urgent need for leadership to discuss next steps. The accompanying charts provide the necessary evidence without competing for visual space.
For a live presentation, however, the same underlying data can be deployed through a more deliberate sequence. Rather than asking an audience to absorb a comprehensive summary all at once while a speaker talks over the slide, a presenter can walk through the overall forecast first. From there, they can gradually reveal the actual role-level changes piece by piece, ultimately steering the conversation toward actionable next steps. This staged approach allows the audience to digest one distinct point before moving on to the next.
While the underlying data and core message remain entirely unchanged, the fundamental difference lies in how much information the audience is asked to process at any given moment. When comprehensive pictures require high levels of detail, the temptation to consolidate everything into a single view remains strong in the name of efficiency. Yet, simply packing more information into a single space does not automatically translate to deeper understanding. By separating the macro-level FTE trend from the granular role-level shifts, both insights become immediately apparent, resulting in a focused, persuasive narrative that leadership can readily act upon.
