Home › Forums › Chart Support › Multiseries column charts › Reply To: Multiseries column charts
(My post must have vanished)
Hello,
I must say that I’m kind of lost in the code. I have like 2000 values and for each one of them, a date associated and I would like to put them into my graph, in the following way for which I put the points myself :
data: [ { type: "line", color: "rgb(85, 118, 180)", showInLegend: true, markerSize: 0, legendMarkerType: "line", legendText: "FONDS", lineThickness: 2, dataPoints: [ { x: new Date(2006, 00, 05), y: 0.00 }, { x: new Date(2006, 00, 07), y: 0.08 }, { x: new Date(2006, 00, 08), y: 0.07 }, { x: new Date(2006, 00, 09), y: 0.09 }, { x: new Date(2006, 00, 11), y: 0.12 }, { x: new Date(2006, 00, 13), y: 0.16 }, { x: new Date(2006, 00, 14), y: 0.11 }, { x: new Date(2006, 00, 15), y: 0.12 }, { x: new Date(2006, 00, 17), y: 0.14 }, { x: new Date(2006, 00, 19), y: 0.22 }, { x: new Date(2006, 00, 20), y: 0.24 }, { x: new Date(2006, 00, 21), y: 0.26 }, { x: new Date(2006, 00, 22), y: -0.05 }, { x: new Date(2006, 00, 24), y: 0.08 }, { x: new Date(2006, 00, 25), y: 0.15 }, { x: new Date(2006, 00, 26), y: 0.36 }, { x: new Date(2006, 00, 28), y: 0.34 }, { x: new Date(2006, 00, 30), y: 0.33 }, { x: new Date(2006, 01, 01), y: 0.33 }, { x: new Date(2006, 01, 02), y: 0.45 }, { x: new Date(2006, 01, 03), y: 0.25 }, { x: new Date(2006, 01, 05), y: 0.60 }, { x: new Date(2006, 01, 06), y: 0.62 }, { x: new Date(2006, 01, 07), y: 0.67 }, { x: new Date(2006, 01, 09), y: 0.50 }, { x: new Date(2006, 01, 11), y: 0.85 }, { x: new Date(2006, 01, 12), y: 1.20 }, { x: new Date(2006, 01, 13), y: 0.78 }, { x: new Date(2006, 01, 14), y: 0.92 }, { x: new Date(2006, 01, 16), y: 0.95 }, { x: new Date(2006, 01, 17), y: 1.36 }, { x: new Date(2006, 01, 18), y: 1.32 }, { x: new Date(2006, 01, 20), y: 1.36 }, { x: new Date(2006, 01, 22), y: 1.23 }, { x: new Date(2006, 01, 23), y: 1.52 }, { x: new Date(2006, 01, 24), y: 1.60 } ] } ]
I would like to understand how to use this sample project to be able to extract those points in my database, which are written in this way : YYYY-MM-DD for the dates (like 2017-08-16) and XXX.XX for the values (like 952.25).
YYYY-MM-DD
2017-08-16
XXX.XX
952.25
Could you help me please? I’m using SQL Server and Microsoft SQL Server Management to handle my database.
Thanks! Tanguy.