Appearance
To make a historical chart in Datawrapper, you upload a clean table, let it detect column types, choose a chart, refine axes and annotations, then publish an embed or export a static image — all in the browser with no code. The free tier is enough for most academic work. The two things that trip historians up are date formatting and how Datawrapper handles missing years, both fixable in setup.
Step 1: Prepare your data the right way
Datawrapper is only as good as the table you paste in. Before uploading: put one variable per column in tidy format, format dates as YYYY or YYYY-MM-DD (convert regnal years to plain years first), leave missing values genuinely blank rather than 0, and strip thousands separators so 12,400 becomes 12400. A spreadsheet like this imports cleanly:
csv
year,baptisms,burials
1701,142,118
1702,,
1703,151,203The blank 1702 row is deliberate — it will become a visible gap, not a fabricated value.
Step 2: Upload and check column types
Paste or upload, then watch the Check & Describe step. Datawrapper colour-codes columns as number (blue), date (green), or text (black). If your year column is not green, it has misread the format — fix the source, do not fight the tool. This is the single most common setup error with historical data.
How do I make missing years show as gaps?
By default Datawrapper interpolates across blanks, drawing a straight line over a decade you have no data for. To stop this:
- Keep the cell blank (step 1).
- In Visualise → Refine, enable "interpolate missing values: off" so the line breaks.
The result honestly signals absence instead of inventing a trend through it.
Step 3: Choose the chart and refine axes
Pick the chart that fits your question, then tune the defaults that matter for history:
| Setting | Where | Recommended for history |
|---|---|---|
| Y-axis start | Refine → Appearance | Zero for counts; label any non-zero baseline |
| Line interpolation | Refine → Lines | Off, so gaps show |
| Number format | Check & Describe | No spurious decimals on counts |
| Direct labels | Refine → Labels | On, instead of a legend |
Direct line labels save readers hopping to a legend — switch them on whenever you have only a few series.
How do I annotate a historical event?
Context is what turns a chart into history. In the Annotate tab, add a range highlight (a shaded band) for a period such as a war or plague, and a vertical line with text label for a single dated event like an enclosure act. Keep annotation type small and grey so it frames the data without competing. Two or three annotations illuminate; a dozen clutter. Write each label to make sense to a reader arriving cold from search.
Step 4: Publish or export
Finish in the Publish & Embed step, which gives two outputs from one chart: a responsive iframe for the web (interactive, with tooltips) and a static PNG, SVG, or PDF for print or a thesis. Use SVG when you want to refine the chart in Inkscape. Always download the static copy too — embeds depend on Datawrapper's servers staying live, and a local file preserves the figure for your archive.
Common pitfalls to avoid
- Zeros standing in for missing data — they distort means and hide gaps.
- Truncated y-axes on counts — reserve for clearly labelled indices.
- Pie charts for change over time — switch to bars or stacked areas.
- Regnal or ambiguous dates — normalise to plain years before upload.
- No caption — state source, denominator, and any smoothing so the chart is reproducible.
Key Takeaways
- Datawrapper needs a tidy table with ISO-style dates and genuinely blank missing cells.
- Verify the detected column types before charting; a non-green date column means a format problem.
- Turn interpolation off so missing years break the line instead of being drawn through.
- Use direct labels and a zero baseline for honest, readable line charts.
- Add sparse range highlights and event lines for historical context.
- Export both the interactive embed and a static SVG/PDF for durability.
Frequently Asked Questions
Is Datawrapper free for historians?
Datawrapper has a free tier sufficient for most academic and small-project use, including unlimited charts and embedding; paid plans add custom themes, larger data, and removal of the small attribution, but the free tier produces fully publishable charts.
How do I get Datawrapper to read historical dates correctly?
Format your date column in a standard ISO style (YYYY or YYYY-MM-DD) and check the column's detected type in the "Check & Describe" step; Datawrapper struggles with regnal years and ambiguous formats, so convert them to plain years first.
Can I embed a Datawrapper chart in a static or academic site?
Yes, every chart gives you a responsive iframe embed code and an exportable static PNG, SVG, or PDF, so you can use the interactive version online and the static version in print or a thesis.
How do I annotate a historical event on a Datawrapper line chart?
Use the "Annotate" tab to add text labels and a range highlight; a shaded range is ideal for marking a war or epidemic period, and a vertical line plus label marks a single dated event.
Why does my Datawrapper chart show gaps as straight lines?
Empty cells are interpolated by default; leave the cell genuinely blank rather than entering zero, and in line-chart settings enable the option to break lines at missing values so absent years are not drawn through.