A blank cell can become a dramatic drop when it enters a charting workflow. If an unavailable monthly result is converted to zero, the finished film may show a collapse that never occurred. Agree how missing values will appear before the data reaches the motion designer, and keep that rule with every revised dataset.
ONS guidance for line charts includes treatment of missing data rather than assuming a continuous observed series. The important commissioning distinction is between an observation that exists and an observation that does not. A zero is a value; an empty cell needs an explanation from the source owner.
Read the gaps with the analyst
Ask for a small data key alongside the approved table. It should explain which entries are measured zeroes, which are unavailable, and whether any special codes have been used. A dash might mean not applicable in one source and suppressed in another. The designer should not guess from appearance.
This matters even when the film contains only a handful of numbers. A hypothetical facilities business might have energy readings for most months but no approved value during a meter replacement. A plunge to zero would imply no consumption. A clear interruption in the series conveys that the record is incomplete without inventing the missing result.
If the data owner supplies an estimated replacement, it should arrive as an approved estimate with an agreed label. Filling the gap is then a documented source decision, not an artistic repair made because an unbroken line looks cleaner.
Describe the absence without overexplaining it
The audience may only need a concise note such as reading unavailable for this period. They do not necessarily need the complete data-cleaning history. Choose wording that explains the limitation relevant to the visible claim and has been approved for release.
Give the note enough proximity to the gap that viewers can connect them. A general caveat at the end of the film is weak protection against a specific false impression earlier. If the missing period is central to the story, the narration may need to address it directly.
Avoid animated bridges that visually restore continuity while the text says data is missing. A dotted connection can have several meanings, including a forecast or an estimate. If one is used, define it; otherwise a genuine break may be clearer.
Test the data import as well as the artwork
Request a proof containing at least one known zero and one known gap. This makes it possible to catch software defaults before the complete sequence is rendered. Check whether blank strings, dashes or special codes have been interpreted consistently across the import.
Keep a record of the approved missing-value treatment in the graphics handover. A later update should not silently join points or introduce zeroes because a different person rebuilt the chart. The same distinction belongs in any companion table or transcript description.
For a data-led project story, bring the source table to a Live Images scope discussion rather than only a screenshot. The film can remain clear about what is known while allowing an honest, legible space for what was not observed.
Prepared with AI assistance for Live Images. Planning guidance is general; suitability and production scope must be agreed for your project.