Scatter plot with multiple series

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>

<h1>Scatter plot with multiple series and datetime axis</h1>
<h2>Chart</h2>
<figure class="highcharts-figure">
    <div id="container"></div>
    <p class="highcharts-description">
        Scatter plot chart with a date/time axis, with multiple data series plotted.
    </p>
</figure>
<h2>CSV data</h2>
<p>
Source: <a href="https://data.world/newns92/abbott-world-marathon-majors-winners">data.world</a>.
</p>
<pre id="csv">year,time,gender,country,name,marathon
1897,02:55:10,Male,United States,John J. McDermott,Boston
1898,02:42:00,Male,Canada,Ronald J. MacDonald,Boston
1899,02:54:38,Male,United States,Lawrence Brignolia,Boston
1900,02:39:44,Male,Canada,Jack Caffery,Boston
1901,02:29:23,Male,Canada,Jack Caffery,Boston
1902,02:43:12,Male,United States,Sammy Mellor,Boston
1903,02:41:29,Male,United States,John Lorden,Boston
1904,02:38:04,Male,United States,Michael Spring,Boston
1905,02:38:25,Male,United States,Frederick Lorz,Boston
1906,02:45:45,Male,United States,Tim Ford,Boston
1907,02:24:24,Male,Canada,Thomas Longboat,Boston
1908,02:25:43,Male,United States,Thomas Morrissey,Boston
1909,02:53:36,Male,United States,Henri Renaud,Boston
1910,02:28:52,Male,Canada,Fred Cameron,Boston
1911,02:21:39,Male,United States,Clarence DeMar,Boston
1912,02:21:18,Male,United States,Michael J. Ryan,Boston
1913,02:25:14,Male,United States,Fritz Carlson,Boston
1914,02:25:14,Male,Canada,James Duffy,Boston
1915,02:31:41,Male,Canada,Edouard Fabre,Boston
1916,02:27:16,Male,United States,Arthur Roth,Boston
1917,02:28:37,Male,United States,Bill Kennedy,Boston
1919,02:29:13,Male,United States,Carl...

CSS

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

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

p {
    margin-left: 1rem;    
}

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

#container {
    height: 500px;
}

.highcharts-figure, .highcharts-data-table table {
    min-width: 320px;
    max-width: 900px;
    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

// Parse CSV to desired format
var csv = document.getElementById('csv').innerHTML;
var rows = csv.split('\n');
rows.shift();
var series = [[], []];
rows.forEach(function (row) {
	var cols = row.split(',');
    if (cols.length < 6 ) {
	    return;
    }
    var timeArr = cols[1].split(':');
    var time = (
    	parseFloat(timeArr[0]) * 60 * 60 +
        parseFloat(timeArr[1]) * 60 +
        parseFloat(timeArr[0])
    ) * 1000;
    var obj = {
    	x: time,
        y: parseFloat(cols[0]),
        custom: {
        	nationality: cols[3],
            name: cols[4],
            marathon: cols[5],
            timeStr: cols[1]
       	}
    };
	series[cols[2] === 'Male' ? 0 : 1].push(obj);
});


// Configure the visualization
var chart = Highcharts.chart('container', {
    chart: {
        type: 'scatter',
        inverted: true
    },
    title: {
        text: 'Marathon winning times 1897-2018'
    },
    subtitle: {
    	text: 'Source: <a href="https://data.world/newns92/abbott-world-marathon-majors-winners">data.world</a>'
    },
    tooltip: {
		formatter: function () {
        	var obj = this.point.custom;
        	return '<span style="font-size: 11px">' + this.series.name + ', ' + this.point.y + ', ' + obj.marathon + '</span><br/>' +
			'<span style="color:' + this.series.color + '">\u25CF</span> ' +
            obj.name + ' (' + obj.nationality + '): <b>' + obj.timeStr + '</b><br/>';
        },
        backgroundColor: 'rgba(255, 255, 255, 0.90)',
        stickOnContact: true
    },
    yAxis: {
    	title: {
        	text: ''
        },
        endOnTick: false
    },
    xAxis: {
    	title: {
        	text: 'Winning time'
        },
        type: 'datetime',
        reversed: false,
        min: 2*60*60*1000
    },
    series: [{
    	name: 'Male class',
        data: series[0],
        color: 'rgba(65, 122, 177, 0.8)'
    }, {
    	name: 'Female class',
        data: series[1],
        color: 'rgba(127, 61, 61, 0.8)'
    }]
});