How to import Json data from a table into Excel

2

I want to generate charts with Chart.js and need to import data from an excel spreadsheet to json in order to draw the chart.

var data = {
labels: ["January", "February", "March", "April", "May", "June", "July"],
datasets: [
    {
        label: "My First dataset",
        fillColor: "rgba(220,220,220,0.2)",
        strokeColor: "rgba(220,220,220,1)",
        pointColor: "rgba(220,220,220,1)",
        pointStrokeColor: "#fff",
        pointHighlightFill: "#fff",
        pointHighlightStroke: "rgba(220,220,220,1)",
        **data: [65, 59, 80, 81, 56, 55, 40]**
    },
    {
        label: "My Second dataset",
        fillColor: "rgba(151,187,205,0.2)",
        strokeColor: "rgba(151,187,205,1)",
        pointColor: "rgba(151,187,205,1)",
        pointStrokeColor: "#fff",
        pointHighlightFill: "#fff",
        pointHighlightStroke: "rgba(151,187,205,1)",
        **data: [28, 48, 40, 19, 86, 27, 90]**
    }
]

};

    
asked by anonymous 07.04.2016 / 15:18

0 answers