Forum Replies Created by lcoulon

Viewing 1 post (of 1 total)
  • January 22, 2017 at 9:28 pm in reply to: Graph a CSV file #14069

    lcoulon

    Hello

    I have a CSV file with datetime timestamps (in milliseconds from 1970) as X axis separed tis a comma ‘,’ and an associated Temperature value as Y axis.

    ie :

    1485097200000,22.5
    1485098100000,23.8
    1485099000000;24.2
    etc …

    From that kind of CSV file i would like to generate a google graph code like this :

    
<script type='text/javascript' src='http://www.google.com/jsapi'></script>

<script type='text/javascript'>

google.load('visualization', '1', {'packages':['annotatedtimeline']});
google.setOnLoadCallback(drawChart);

function drawChart() {

    var data = new google.visualization.DataTable();
    data.addColumn('datetime', 'Date');
    data.addColumn('number', 'Temperatures');
    data.addRows([
        [new Date(1485097200000), 22.5],
        [new Date(1485098100000), 23.8],
        [new Date(1485099000000), 24.2],
        // ...

        ]);

    var chart = new google.visualization.AnnotatedTimeLine(document.getElementById('chart_div'));
    chart.draw(data, {displayAnnotations: true});

    }
</script>

    Would you please tell if it is possible and how i could do it, i’m newbie.
    https://jsfiddle.net/99guxm3b/5/
    Regards,

Viewing 1 post (of 1 total)