I have the following rows with columns declared with zero value, when the value for when I have no data for it ... however it does not display the graph correctly ... How to add empty data for the column so that the row will go through the middle value between last record and current record ?:
function DrawChart() { // Create the data table. var data = new google.visualization.DataTable(); data.addColumn('date', 'Date'); data.addColumn('number', 'a name'); data.addColumn('number', 'a name 2'); data.addColumn('number', 'a name 3'); data.addRows( [ [new Date( 2013, 7, 1 ),1.5,null,null], [new Date( 2013, 6, 28 ),-1.5,null,null], [new Date( 2013, 6, 21 ),null,-1,null], [new Date( 2013, 6, 15 ),null,0,2], [new Date( 2013, 6, 7 ),1.5,null,null], [new Date( 2013, 6, 5 ),-1,null,null], [new Date( 2013, 6, 1 ),0.5,2,null], ] ); // Set chart options var options = { 'title': 'tracker', 'width': 800, 'height': 600, 'backgroundColor': 'transparent', chartArea: { left: 'auto', top: 'auto' }, hAxis: { title: 'Date of bla', titleTextStyle: { italic: false }, gridlines: { color: "#E3E3E3" }, showTextEvery: 1 }, vAxis: { title: 'Positivity', titleTextStyle: { italic: false }, gridlines: { color: "#E3E3E3" } } }; // Instantiate and draw our chart, passing in some options. var chart = new google.visualization.LineChart( document.getElementById('chartDiv') ); google.visualization.events.addListener( chart, 'select', selectHandler ); chart.draw(data, options); } </script>
https://developers.google.com/chart/interactive/docs/reference#DataTable
Entering 0 instead of zero means that the data will be displayed as 0 .. I do not want this to happen .. And if I put the average between the oldest and latest data, will it still be a selectable point that I also don’t want?