Area line chart with missing data

author(s): Øystein Moseng

by oysteinmoseng

HTML

<script src="https://code.highcharts.com/highcharts.js"></script>
<script src="https://code.highcharts.com/modules/data.js"></script>
<script src="https://code.highcharts.com/modules/exporting.js"></script>
<script src="https://code.highcharts.com/modules/export-data.js"></script>
<script src="https://code.highcharts.com/modules/accessibility.js"></script>
<script src="https://code.highcharts.com/themes/high-contrast-light.js"></script>

<h1>Line chart with missing data</h1>
<h2>Chart</h2>
<figure class="highcharts-figure">
    <div id="container"></div>
    <p class="highcharts-description">
        Time series smoothed area line chart with missing data.
    </p>
</figure>
<h2>CSV data</h2>
<p>
    Source: <a href="https://data.world/yoda/running-since-1999">data.world</a>
</p>
<pre id="csv">01/11/2020,Alameda,1487
01/11/2020,Contra Costa,1073
01/11/2020,Marin,144
01/11/2020,Napa,162
01/11/2020,San Francisco,945
01/11/2020,San Mateo,467
01/11/2020,Santa Clara,1443
01/11/2020,Solano,678
01/11/2020,Sonoma,558
01/18/2020,Alameda,1817
01/18/2020,Contra Costa,1383
01/18/2020,Marin,202
01/18/2020,Napa,185
01/18/2020,San Francisco,965
01/18/2020,San Mateo,597
01/18/2020,Santa Clara,1794
01/18/2020,Solano,825
01/18/2020,Sonoma,640
01/25/2020,Alameda,1350
01/25/2020,Contra Costa,940
01/25/2020,Marin,146
01/25/2020,Napa,157
01/25/2020,San Francisco,739
01/25/2020,San Mateo,438
01/25/2020,Santa Clara,1330
01/25/2020,Solano,574
01/25/2020,Sonoma,503
02/01/2020,Alameda,1265
02/01/2020,Contra Costa,949
02/01/2020,Marin,154
02/01/2020,Napa,140
02/01/2020,San Francisco,801
02/01/2020,San Mateo,384
02/01/2020,Santa Clara,1133
02/01/2020,Solano,567
02/01/2020,Sonoma,453
02/08/2020,Alameda,1328
02/08/2020,Contra Costa,867
02/08/2020,Marin,138
02/08/2020,Napa,130
02/08/2020,San Francisco,824
02/08/2020,San Mateo,444
02/08/2020,Santa Clara,1369
02/08/2020,Solano,516
02/08/2020,Sonoma,414
02/15/2020,Alameda,1371
02/15/2020,Contra...

CSS

body {
  font-family: Verdana, sans-serif;
  padding-left: 10px;
}

p {
    margin-left: 1rem;
}

h2 {
  font-size: 1.3rem;
  margin-left: 10px;
  margin-bottom: 0;
  margin-top: 1.5rem;
}

pre {
  margin-left: 1rem;
  border: 1px solid #cde;
  max-width: 800px;
  padding: 10px;
  background-color: #f9f9f9;
  border-radius: 10px;
}

#container {
    height: 400px;
}

.highcharts-figure, .highcharts-data-table table {
    min-width: 320px;
    max-width: 800px;
    margin: 1em;
}

.highcharts-data-table table {
	font-family: Verdana, sans-serif;
	border-collapse: collapse;
	border: 1px solid #EBEBEB;
	margin: 10px auto;
	text-align: center;
	width: 100%;
	max-width: 500px;
}
.highcharts-data-table caption {
    padding: 1em 0;
    font-size: 1.2em;
    color: #555;
}
.highcharts-data-table th {
	font-weight: 600;
    padding: 0.5em;
}
.highcharts-data-table td, .highcharts-data-table th, .highcharts-data-table caption {
    padding: 0.5em;
}
.highcharts-data-table thead tr, .highcharts-data-table tr:nth-child(even) {
    background: #f8f8f8;
}
.highcharts-data-table tr:hover {
    background: #f1f7ff;
}


input[type="number"] {
	min-width: 50px;
}

JavaScript

const csv = document.getElementById('csv').innerHTML;
const rows = csv.split('\n');
const counties = {};
rows.forEach((row) => {
	const cols = row.split(',');
    const dateStr = cols[0].split('/');
    const date = new Date(Date.UTC(
    	parseFloat(cols[2]),
        parseFloat(cols[0])
    ));
});

var chart = Highcharts.chart('container', {
    chart: {
        type: 'areaspline'
    },
    title: {
        text: 'Weekly mileage of a runner, 1999-2000'
    },
    subtitle: {
	    text: 'Source: <a href="https://data.world/yoda/running-since-1999">data.world</a>, modified'
    },
    tooltip: {
        stickOnContact: true
    },
    xAxis: {
    	type: 'datetime'
    },
    legend: {
    	enabled: false
    },
    yAxis: {
    	title: {
        	text: 'Miles'
        },
        endOnTick: false
    },
    data: {
    	csv: document.getElementById('csv').innerHTML
    }
});