Dates and Missing Values

Plot irregular measurements at their actual distances and make gaps clear.

Use a date axis for elapsed time

Use YYYY-MM-DD for an unambiguous date. For example, June 1 and June 3 sit closer together than June 3 and June 10. On a category axis all three labels are evenly spaced.

Show what was measured

Leave a blank cell when a measurement was never taken. The line breaks at that reading by default. Connect missing values only when connecting observed endpoints makes sense for the chart.

Open the editor