# Need help with line chart

**URL:** <https://discourse.nodered.org/t/need-help-with-line-chart/11678>\
**Category:** Dashboard\
**Created:** [29 May 2019 18:14 UTC](https://discourse.nodered.org/t/need-help-with-line-chart/11678 "2019-05-29T18:14:52Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![mastershot24](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mastershot24/32/8857_2.png) [@mastershot24](https://discourse.nodered.org/u/mastershot24)\
**Post date:** [29 May 2019 18:14 UTC](https://discourse.nodered.org/t/need-help-with-line-chart/11678/1 "2019-05-29T18:14:52Z")

</div>

Hello everyone. I'm just using node red a week ago. I can get the data from database to make a line chart but i don't know how to make a chart with multiple type of data taken from database. My flow is below. This is the first time i post so if something wrong please let me know.  
P/s: sorry for my bad english and thank for reading my post 🙂

```auto
 [{"id":"66115379.8c654c","type":"inject","z":"eff85edf.d773b","name":"Node 2","topic":"","payload":"","payloadType":"date","repeat":"10","crontab":"","once":true,"onceDelay":0.1,"x":120,"y":260,"wires":[["d4a6fb67.e84f78","2fa0028b.ae6cbe","e7a983c2.03d8a"]]},{"id":"d4a6fb67.e84f78","type":"function","z":"eff85edf.d773b","name":"","func":"msg.topic = \"SELECT datetime,value FROM sensordata WHERE name = 'Temp' AND node = '2'\";\nreturn msg;","outputs":1,"noerr":0,"x":280,"y":260,"wires":[["121ac9a2.1faab6"]]},{"id":"ba57b212.062f1","type":"change","z":"eff85edf.d773b","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"[\t{ \"key\": \"value\", \"values\": msg.payload.[datetime,value] }\t]","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":630,"y":260,"wires":[["78d5f82c.d03618"]]},{"id":"78d5f82c.d03618","type":"ui_chart","z":"eff85edf.d773b","name":"","group":"a8f7387.b3261c8","order":1,"width":"6","height":"3","label":"Nhiệt Độ","chartType":"line","legend":"false","xformat":"auto","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"86400","cutout":0,"useOneColor":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":820,"y":260,"wires":[[]]},{"id":"121ac9a2.1faab6","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":430,"y":260,"wires":[["ba57b212.062f1"]]},{"id":"2fa0028b.ae6cbe","type":"function","z":"eff85edf.d773b","name":"","func":"msg.topic = \"SELECT datetime,value FROM sensordata WHERE name = 'Air Humidity' AND node = '2'\";\nreturn msg;","outputs":1,"noerr":0,"x":280,"y":320,"wires":[["83e6fc26.08287"]]},{"id":"159a0e51.2c1d42","type":"change","z":"eff85edf.d773b","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"[\t{ \"key\": \"value\", \"values\": msg.payload.[datetime,value] }\t]","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":630,"y":320,"wires":[["84babd7d.7c9eb"]]},{"id":"84babd7d.7c9eb","type":"ui_chart","z":"eff85edf.d773b","name":"","group":"a8f7387.b3261c8","order":2,"width":"6","height":"3","label":"Độ Ẩm Không Khí","chartType":"line","legend":"false","xformat":"auto","interpolate":"linear","nodata":"C","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"86400","cutout":0,"useOneColor":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":850,"y":320,"wires":[[]]},{"id":"83e6fc26.08287","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":430,"y":320,"wires":[["159a0e51.2c1d42"]]},{"id":"e7a983c2.03d8a","type":"function","z":"eff85edf.d773b","name":"","func":"msg.topic = \"SELECT datetime,value FROM sensordata WHERE name = 'Soil Humidity' AND node = '2'\";\nreturn msg;","outputs":1,"noerr":0,"x":280,"y":380,"wires":[["102e2f46.495be1"]]},{"id":"b73685a7.3c5a28","type":"change","z":"eff85edf.d773b","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"[\t{ \"key\": \"value\", \"values\": msg.payload.[datetime,value] }\t]","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":630,"y":380,"wires":[["5b436ab.507d194"]]},{"id":"5b436ab.507d194","type":"ui_chart","z":"eff85edf.d773b","name":"","group":"a8f7387.b3261c8","order":3,"width":"6","height":"3","label":"Độ Ẩm Đất","chartType":"line","legend":"false","xformat":"auto","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"86400","cutout":0,"useOneColor":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":830,"y":380,"wires":[[]]},{"id":"102e2f46.495be1","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":430,"y":380,"wires":[["b73685a7.3c5a28"]]},{"id":"a8f7387.b3261c8","type":"ui_group","z":"","name":"Node 2","tab":"e070434f.c4a94","order":2,"disp":true,"width":"6","collapse":false},{"id":"b0c7d675.9f98a8","type":"MySQLdatabase","z":"","host":"127.0.0.1","port":"3306","db":"sensordata","tz":"GMT + 7"},{"id":"e070434f.c4a94","type":"ui_tab","z":"","name":"Biểu đồ","icon":"pie_chart","order":3,"disabled":false,"hidden":false}]

```

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [29 May 2019 18:59 UTC](https://discourse.nodered.org/t/need-help-with-line-chart/11678/2 "2019-05-29T18:59:30Z")

</div>

Welcome to the forum! I'm sure as you use it more you will see what power Node-Red has.

Now to your question and first thing I'm going to ask is did you do a search of the forum using 'line chart'?  
I think you might find some people who have already asked and solved this same problem.

---

<div class="post-metadata">

**Author:** ![Robbo](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/robbo/32/4491_2.png) [@Robbo](https://discourse.nodered.org/u/Robbo)\
**Post date:** [29 May 2019 19:40 UTC](https://discourse.nodered.org/t/need-help-with-line-chart/11678/3 "2019-05-29T19:40:16Z")

</div>

If you need advance chart stuff, then take a look at Grafana.

---

<div class="post-metadata">

**Author:** ![mastershot24](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mastershot24/32/8857_2.png) [@mastershot24](https://discourse.nodered.org/u/mastershot24)\
**Post date:** [29 May 2019 19:56 UTC](https://discourse.nodered.org/t/need-help-with-line-chart/11678/4 "2019-05-29T19:56:58Z")

</div>

Yes, I've search for solution before I post this. I know that we can get multiple data line in one chart by change the msg.topic for each type but mine is not working right. They keep change from type 1 to 2 then back to 1 then 2... But not both at the same time. ☹ I don't know how to fix that.

---

<div class="post-metadata">

**Author:** ![mastershot24](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mastershot24/32/8857_2.png) [@mastershot24](https://discourse.nodered.org/u/mastershot24)\
**Post date:** [29 May 2019 19:59 UTC](https://discourse.nodered.org/t/need-help-with-line-chart/11678/5 "2019-05-29T19:59:17Z")

</div>

Thanks for your reply but I didn't need that much just need three line data in one chart 😄 that enough for me.

---

<div class="post-metadata">

**Author:** ![Andrei](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/andrei/32/10446_2.png) [@Andrei](https://discourse.nodered.org/u/Andrei)\
**Post date:** [29 May 2019 20:34 UTC](https://discourse.nodered.org/t/need-help-with-line-chart/11678/6 "2019-05-29T20:34:34Z")

</div>

What you want to achieve is explained in the below post, more specifically on the paragraph "Stored Data".  
Basically you want to build 3 arrays and send them with a statement like the one below inside a function node:

```auto
msg.payload = [{"series":series, "data":data,"labels": labels}]

```

> <https://github.com/node-red/node-red-dashboard/blob/master/Charts.md>

PS: Try out the example at the bottom of that page. You will see all kinds of line charts depicted.

 ![nr-chart-example](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/b/b95d23978c1a7d7da78d7fcea9a3a2964e4410d8.png)

---

<div class="post-metadata">

**Author:** ![mastershot24](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mastershot24/32/8857_2.png) [@mastershot24](https://discourse.nodered.org/u/mastershot24)\
**Post date:** [30 May 2019 06:47 UTC](https://discourse.nodered.org/t/need-help-with-line-chart/11678/7 "2019-05-30T06:47:11Z")

</div>

> [@Andrei](#):
>
> "series":series,

thanks but i have read it before i have already made 3 array and i don't know how to combine them into one to send to chart node.

```auto
[{"id":"fb70e207.920b","type":"function","z":"eff85edf.d773b","name":"","func":"msg.topic = \"SELECT datetime,value FROM sensordata WHERE name = 'Temp' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":270,"y":80,"wires":[["333aa491.129cec"]]},{"id":"333aa491.129cec","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":420,"y":80,"wires":[["8032716f.3c6c1"]]},{"id":"2f02b139.72b73e","type":"function","z":"eff85edf.d773b","name":"","func":"msg.topic = \"SELECT datetime,value FROM sensordata WHERE name = 'Air Humidity' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":270,"y":140,"wires":[["d80d042d.f2f6b8"]]},{"id":"609977c4.738c98","type":"ui_chart","z":"eff85edf.d773b","name":"","group":"3a82b53.88c104a","order":2,"width":"6","height":"3","label":"Độ Ẩm Không Khí","chartType":"line","legend":"false","xformat":"auto","interpolate":"linear","nodata":"C","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"86400","cutout":0,"useOneColor":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":830,"y":140,"wires":[[]]},{"id":"d80d042d.f2f6b8","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":420,"y":140,"wires":[["7a068f0d.3c43a"]]},{"id":"70afd92d.e05238","type":"function","z":"eff85edf.d773b","name":"","func":"msg.topic = \"SELECT datetime,value FROM sensordata WHERE name = 'Soil Humidity' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":270,"y":200,"wires":[["a92bb512.59a6d8"]]},{"id":"900388c5.5963f8","type":"change","z":"eff85edf.d773b","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"[\t {\t \"key\": \"Độ ẩm đất\",\t \"values\": msg.payload.[datetime,value] \t }\t\t]","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":620,"y":200,"wires":[["b02944a1.5aa128"]]},{"id":"b02944a1.5aa128","type":"ui_chart","z":"eff85edf.d773b","name":"","group":"3a82b53.88c104a","order":3,"width":"6","height":"3","label":"Độ Ẩm Đất","chartType":"line","legend":"false","xformat":"auto","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"86400","cutout":0,"useOneColor":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":820,"y":200,"wires":[[]]},{"id":"a92bb512.59a6d8","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":420,"y":200,"wires":[["900388c5.5963f8"]]},{"id":"68a5a72a.917bc8","type":"inject","z":"eff85edf.d773b","name":"Node 1","topic":"","payload":"","payloadType":"date","repeat":"10","crontab":"","once":true,"onceDelay":0.1,"x":110,"y":80,"wires":[["fb70e207.920b","2f02b139.72b73e","70afd92d.e05238"]]},{"id":"7a068f0d.3c43a","type":"change","z":"eff85edf.d773b","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"[\t {\t \"key\": \"Độ ẩm không khí\",\t \"values\": msg.payload.[datetime,value] \t }\t]","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":620,"y":140,"wires":[["609977c4.738c98"]]},{"id":"6f623de9.671e04","type":"ui_chart","z":"eff85edf.d773b","name":"","group":"3a82b53.88c104a","order":1,"width":"6","height":"3","label":"Nhiệt Độ","chartType":"line","legend":"false","xformat":"auto","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"86400","cutout":0,"useOneColor":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":820,"y":80,"wires":[[]]},{"id":"8032716f.3c6c1","type":"change","z":"eff85edf.d773b","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"[\t{ \"key\": \"Nhiệt độ\", \"values\": msg.payload.[datetime,value] }\t]","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":620,"y":80,"wires":[["6f623de9.671e04"]]},{"id":"b0c7d675.9f98a8","type":"MySQLdatabase","z":"","host":"127.0.0.1","port":"3306","db":"sensordata","tz":"GMT + 7"},{"id":"3a82b53.88c104a","type":"ui_group","z":"","name":"Node 1","tab":"e070434f.c4a94","order":1,"disp":true,"width":"6","collapse":false},{"id":"e070434f.c4a94","type":"ui_tab","z":"","name":"Biểu đồ","icon":"pie_chart","order":3,"disabled":false,"hidden":false}]

```

> Blockquote Here is my database  
> +----------+----------+------+-----+---------+----------------+  
> | Field | Type | Null | Key | Default | Extra |  
> +----------+----------+------+-----+---------+----------------+  
> | name | text | YES | | NULL | |  
> | node | text | YES | | NULL | |  
> | datetime | datetime | YES | | NULL | |  
> | value | float | YES | | NULL | |  
> | id | int(11) | NO | PRI | NULL | auto\_increment |  
> +----------+----------+------+-----+---------+----------------+

---

<div class="post-metadata">

**Author:** ![Andrei](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/andrei/32/10446_2.png) [@Andrei](https://discourse.nodered.org/u/Andrei)\
**Post date:** [30 May 2019 15:47 UTC](https://discourse.nodered.org/t/need-help-with-line-chart/11678/8 "2019-05-30T15:47:59Z")

</div>

You have to generate a structure exactly like explained in the docs.

The object in the array is suposed to have 3 keys: "series", "data" and "labels". The values of these keys have to be arrays.

The data structure you are creating is quite different. It is not going to work (as you already realised).

```auto
[{
    "series": ["X", "Y", "Z"],
    "data": [[5,6,9], [3,8,5], [6,7,2] ],
    "labels": ["Jan", "Feb", "Mar"]
}]

```

```auto
[{ "key": "Độ ẩm đất", "values": msg.payload.[datetime,value] }	]

```

---

<div class="post-metadata">

**Author:** ![baqwas](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/baqwas/32/106_2.png) [@baqwas](https://discourse.nodered.org/u/baqwas)\
**Post date:** [31 May 2019 14:05 UTC](https://discourse.nodered.org/t/need-help-with-line-chart/11678/9 "2019-05-31T14:05:31Z")

</div>

Hello,

Use **msg.topic** to identify each type of data you are feeding to your single chart.

Regards.

---

<div class="post-metadata">

**Author:** ![mastershot24](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mastershot24/32/8857_2.png) [@mastershot24](https://discourse.nodered.org/u/mastershot24)\
**Post date:** [1 June 2019 16:00 UTC](https://discourse.nodered.org/t/need-help-with-line-chart/11678/10 "2019-06-01T16:00:29Z")

</div>

Sorry for late reply because i have other work to do.  
So i have change my code like you told me but when deploy i see 2 legend for a second and then and chart become white i don't know what wrong ☹  
Below is my flow after change.

```auto
[{"id":"33821100.82fc8","type":"function","z":"eff85edf.d773b","name":"all","func":"var datehumi1 = flow.get(\"datehumi1\");\nvar humi1 = flow.get(\"humi1\");\nvar datetemp1 = flow.get(\"datetemp1\");\nvar temp1 = flow.get(\"temp1\");\n\nmsg.payload= [{\n \"series\": [\"X\", \"Y\"],\n \"data\": [[datetemp1,temp1], [datehumi1,humi1]],\n \"labels\": [\"Temperature\", \"Humidity\"]\n}];\nreturn msg;","outputs":1,"noerr":0,"x":810,"y":60,"wires":[["6f623de9.671e04"]]},{"id":"325e745e.c83dbc","type":"function","z":"eff85edf.d773b","name":"SQL Query","func":"var datetemp1=msg.payload;\nvar temp1=msg.payload;\ndatetemp1 = datetemp1['datetime']\ntemp1 = temp1['value']\nflow.set(\"datetemp1\",datetemp1);\nflow.set(\"temp1\",temp1);\nreturn msg;","outputs":1,"noerr":0,"x":610,"y":40,"wires":[["33821100.82fc8"]]},{"id":"6f623de9.671e04","type":"ui_chart","z":"eff85edf.d773b","name":"","group":"3a82b53.88c104a","order":1,"width":"6","height":"3","label":"Nhiệt Độ","chartType":"line","legend":"true","xformat":"auto","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"86400","cutout":0,"useOneColor":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":940,"y":60,"wires":[[]]},{"id":"b500e753.09f3f8","type":"function","z":"eff85edf.d773b","name":"SQL Query","func":"var datehumi1=msg.payload;\nvar humi1=msg.payload;\ndatehumi1 = datehumi1['datetime']\nhumi1 = humi1['value']\nflow.set(\"datehumi1\",datehumi1);\nflow.set(\"humi1\",humi1);\nreturn msg;","outputs":1,"noerr":0,"x":610,"y":100,"wires":[["33821100.82fc8"]]},{"id":"333aa491.129cec","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":420,"y":80,"wires":[["325e745e.c83dbc"]]},{"id":"d80d042d.f2f6b8","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":420,"y":140,"wires":[["7a068f0d.3c43a","b500e753.09f3f8"]]},{"id":"2f02b139.72b73e","type":"function","z":"eff85edf.d773b","name":"","func":"msg.topic = \"SELECT datetime,value FROM sensordata WHERE name = 'Air Humidity' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":270,"y":140,"wires":[["d80d042d.f2f6b8"]]},{"id":"fb70e207.920b","type":"function","z":"eff85edf.d773b","name":"","func":"msg.topic = \"SELECT datetime,value FROM sensordata WHERE name = 'Temp' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":270,"y":80,"wires":[["333aa491.129cec"]]},{"id":"68a5a72a.917bc8","type":"inject","z":"eff85edf.d773b","name":"Node 1","topic":"","payload":"","payloadType":"date","repeat":"10","crontab":"","once":true,"onceDelay":0.1,"x":110,"y":80,"wires":[["fb70e207.920b","2f02b139.72b73e","70afd92d.e05238"]]},{"id":"3a82b53.88c104a","type":"ui_group","z":"","name":"Khu vực 1","tab":"e070434f.c4a94","order":1,"disp":true,"width":"6","collapse":false},{"id":"b0c7d675.9f98a8","type":"MySQLdatabase","z":"","host":"127.0.0.1","port":"3306","db":"sensordata","tz":"GMT + 7"},{"id":"e070434f.c4a94","type":"ui_tab","z":"","name":"Biểu đồ","icon":"pie_chart","order":3,"disabled":false,"hidden":false}]

```

---

<div class="post-metadata">

**Author:** ![mastershot24](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mastershot24/32/8857_2.png) [@mastershot24](https://discourse.nodered.org/u/mastershot24)\
**Post date:** [1 June 2019 16:01 UTC](https://discourse.nodered.org/t/need-help-with-line-chart/11678/11 "2019-06-01T16:01:42Z")

</div>

But it seem like not work for me cause mine input is and array of data ☹

---

<div class="post-metadata">

**Author:** ![Andrei](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/andrei/32/10446_2.png) [@Andrei](https://discourse.nodered.org/u/Andrei)\
**Post date:** [1 June 2019 17:18 UTC](https://discourse.nodered.org/t/need-help-with-line-chart/11678/12 "2019-06-01T17:18:10Z")

</div>

If your data is indexed to time (time-series data) then, according to the documentation, you have to transform your data structure to follow below pattern, where "x" is time and "y" is the value (temperature or humidity).

```auto
[{
"series": ["A", "B", "C"],
"data": [
    [{ "x": 1504029632890, "y": 5 },
     { "x": 1504029636001, "y": 4 },
     { "x": 1504029638656, "y": 2 }
    ],
    [{ "x": 1504029633514, "y": 6 },
     { "x": 1504029636622, "y": 7 },
     { "x": 1504029639539, "y": 6 }
    ],
    [{ "x": 1504029634400, "y": 7 },
     { "x": 1504029637959, "y": 7 },
     { "x": 1504029640317, "y": 7 }
    ]
],
"labels": [""]
}]

```

---

<div class="post-metadata">

**Author:** ![baqwas](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/baqwas/32/106_2.png) [@baqwas](https://discourse.nodered.org/u/baqwas)\
**Post date:** [1 June 2019 17:38 UTC](https://discourse.nodered.org/t/need-help-with-line-chart/11678/13 "2019-06-01T17:38:07Z")

</div>

Hello mastershot24,

Andrei has illustrated an example for _your_ case/requirement. I haven't checked where the Legend setting is overridden by the values in the labels array. In fact, the same structure is output by Line Chart as the first payload. (I don't know what the second output payload does. 😟).

Regards.

---

<div class="post-metadata">

**Author:** ![mastershot24](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mastershot24/32/8857_2.png) [@mastershot24](https://discourse.nodered.org/u/mastershot24)\
**Post date:** [2 June 2019 04:34 UTC](https://discourse.nodered.org/t/need-help-with-line-chart/11678/14 "2019-06-02T04:34:13Z")

</div>

I have transform data like the structure you showing me but this time the legend is stand still it not disappear anymore but the data is missing.

```auto
[{"id":"6f623de9.671e04","type":"ui_chart","z":"eff85edf.d773b","name":"","group":"3a82b53.88c104a","order":1,"width":"6","height":"6","label":"Nhiệt Độ","chartType":"line","legend":"true","xformat":"auto","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"86400","cutout":0,"useOneColor":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":true,"outputs":1,"x":1140,"y":60,"wires":[[]]},{"id":"9d8dba1.5394848","type":"debug","z":"eff85edf.d773b","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":1160,"y":160,"wires":[]},{"id":"88cc3ae4.73ba48","type":"function","z":"eff85edf.d773b","name":"all","func":"var datehumi1 = flow.get(\"datehumi1\");\nvar humi1 = flow.get(\"humi1\");\nvar datetemp1 = flow.get(\"datetemp1\");\nvar temp1 = flow.get(\"temp1\");\n\nmsg.payload= [{\n\"series\": [\"A\", \"B\"],\n\"data\": [\n [{ \"x\": datetemp1, \"y\": temp1 }],\n [{ \"x\": datehumi1, \"y\": humi1 }]\n],\n\"labels\": [\"\"]\n}]\nreturn msg;","outputs":1,"noerr":0,"x":970,"y":60,"wires":[["6f623de9.671e04","9d8dba1.5394848"]]},{"id":"e392ec04.b09e8","type":"function","z":"eff85edf.d773b","name":"SQL Query","func":"var datehumi1=msg.payload;\nvar humi1=msg.payload;\ndatehumi1 = datehumi1['datetime']\nhumi1 = humi1['value']\nflow.set(\"datehumi1\",datehumi1);\nflow.set(\"humi1\",humi1);\nreturn msg;","outputs":1,"noerr":0,"x":810,"y":100,"wires":[["88cc3ae4.73ba48"]]},{"id":"1d5c4cc0.255883","type":"function","z":"eff85edf.d773b","name":"SQL Query","func":"var datetemp1=msg.payload;\nvar temp1=msg.payload;\ndatetemp1 = datetemp1['datetime']\ntemp1 = temp1['value']\nflow.set(\"datetemp1\",datetemp1);\nflow.set(\"temp1\",temp1);\nreturn msg;","outputs":1,"noerr":0,"x":810,"y":40,"wires":[["88cc3ae4.73ba48"]]},{"id":"333aa491.129cec","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":420,"y":80,"wires":[["1d5c4cc0.255883"]]},{"id":"d80d042d.f2f6b8","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":420,"y":140,"wires":[["7a068f0d.3c43a","e392ec04.b09e8"]]},{"id":"2f02b139.72b73e","type":"function","z":"eff85edf.d773b","name":"","func":"msg.topic = \"SELECT datetime,value FROM sensordata WHERE name = 'Air Humidity' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":270,"y":140,"wires":[["d80d042d.f2f6b8"]]},{"id":"fb70e207.920b","type":"function","z":"eff85edf.d773b","name":"","func":"msg.topic = \"SELECT datetime,value FROM sensordata WHERE name = 'Temp' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":270,"y":80,"wires":[["333aa491.129cec"]]},{"id":"68a5a72a.917bc8","type":"inject","z":"eff85edf.d773b","name":"Node 1","topic":"","payload":"","payloadType":"date","repeat":"10","crontab":"","once":true,"onceDelay":0.1,"x":110,"y":80,"wires":[["fb70e207.920b","2f02b139.72b73e","70afd92d.e05238"]]},{"id":"3a82b53.88c104a","type":"ui_group","z":"","name":"Khu vực 1","tab":"e070434f.c4a94","order":1,"disp":true,"width":"6","collapse":false},{"id":"b0c7d675.9f98a8","type":"MySQLdatabase","z":"","host":"127.0.0.1","port":"3306","db":"sensordata","tz":"GMT + 7"},{"id":"e070434f.c4a94","type":"ui_tab","z":"","name":"Biểu đồ","icon":"pie_chart","order":4,"disabled":false,"hidden":true}]

```

---

<div class="post-metadata">

**Author:** ![mastershot24](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mastershot24/32/8857_2.png) [@mastershot24](https://discourse.nodered.org/u/mastershot24)\
**Post date:** [2 June 2019 04:49 UTC](https://discourse.nodered.org/t/need-help-with-line-chart/11678/15 "2019-06-02T04:49:58Z")

</div>

> [@Andrei](#):
>
> "x": 1504029632890, "y": 5

After a few split data is not empty anymore but it still doesn't show on the chart ☹

```auto
[{"id":"fb70e207.920b","type":"function","z":"eff85edf.d773b","name":"value","func":"msg.topic = \"SELECT value FROM sensordata WHERE name = 'Temp' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":270,"y":40,"wires":[["333aa491.129cec"]]},{"id":"333aa491.129cec","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":430,"y":40,"wires":[["1d5c4cc0.255883"]]},{"id":"2f02b139.72b73e","type":"function","z":"eff85edf.d773b","name":"value","func":"msg.topic = \"SELECT value FROM sensordata WHERE name = 'Air Humidity' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":270,"y":120,"wires":[["d80d042d.f2f6b8"]]},{"id":"d80d042d.f2f6b8","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":430,"y":120,"wires":[["e392ec04.b09e8"]]},{"id":"68a5a72a.917bc8","type":"inject","z":"eff85edf.d773b","name":"Node 1","topic":"","payload":"","payloadType":"date","repeat":"10","crontab":"","once":true,"onceDelay":0.1,"x":110,"y":80,"wires":[["fb70e207.920b","2f02b139.72b73e","70afd92d.e05238","4f5750ba.fb25c","c88d09cc.0e77d8"]]},{"id":"6f623de9.671e04","type":"ui_chart","z":"eff85edf.d773b","name":"","group":"3a82b53.88c104a","order":1,"width":"6","height":"6","label":"Nhiệt Độ","chartType":"line","legend":"true","xformat":"auto","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"86400","cutout":0,"useOneColor":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":true,"outputs":1,"x":1140,"y":60,"wires":[[]]},{"id":"88cc3ae4.73ba48","type":"function","z":"eff85edf.d773b","name":"all","func":"var datehumi1 = flow.get(\"datehumi1\");\nvar humi1 = flow.get(\"humi1\");\nvar datetemp1 = flow.get(\"datetemp1\");\nvar temp1 = flow.get(\"temp1\");\n\nmsg.payload= [{\n\"series\": [\"A\", \"B\"],\n\"data\": [\n [{ \"x\": datetemp1, \"y\":temp1 }],\n [{ \"x\": datehumi1, \"y\":humi1 }]\n],\n\"labels\": [\"\"]\n}]\nreturn msg;","outputs":1,"noerr":0,"x":910,"y":100,"wires":[["6f623de9.671e04","9d8dba1.5394848"]]},{"id":"1d5c4cc0.255883","type":"function","z":"eff85edf.d773b","name":"SQL Query","func":"var temp1=msg.payload;\nflow.set(\"temp1\",temp1);\nreturn msg;","outputs":1,"noerr":0,"x":630,"y":40,"wires":[["88cc3ae4.73ba48"]]},{"id":"e392ec04.b09e8","type":"function","z":"eff85edf.d773b","name":"SQL Query","func":"var humi1=msg.payload;\nflow.set(\"humi1\",humi1);\nreturn msg;","outputs":1,"noerr":0,"x":630,"y":120,"wires":[["88cc3ae4.73ba48"]]},{"id":"9d8dba1.5394848","type":"debug","z":"eff85edf.d773b","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":1130,"y":100,"wires":[]},{"id":"4f5750ba.fb25c","type":"function","z":"eff85edf.d773b","name":"datetime","func":"msg.topic = \"SELECT datetime FROM sensordata WHERE name = 'Temp' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":280,"y":80,"wires":[["cbabecd.553711"]]},{"id":"cbabecd.553711","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":430,"y":80,"wires":[["2f65d719.695088"]]},{"id":"2f65d719.695088","type":"function","z":"eff85edf.d773b","name":"SQL Query","func":"var datetemp1=msg.payload;\nflow.set(\"datetemp1\",datetemp1);\nreturn msg;","outputs":1,"noerr":0,"x":630,"y":80,"wires":[["88cc3ae4.73ba48"]]},{"id":"5dca2d1e.adfa64","type":"function","z":"eff85edf.d773b","name":"SQL Query","func":"var datehumi1=msg.payload;\nflow.set(\"datehumi1\",datehumi1);\nreturn msg;","outputs":1,"noerr":0,"x":630,"y":160,"wires":[["88cc3ae4.73ba48"]]},{"id":"c88d09cc.0e77d8","type":"function","z":"eff85edf.d773b","name":"datetime","func":"msg.topic = \"SELECT datetime FROM sensordata WHERE name = 'Air Humidity' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":280,"y":160,"wires":[["a9dbf147.31aa8"]]},{"id":"a9dbf147.31aa8","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":430,"y":160,"wires":[["5dca2d1e.adfa64"]]},{"id":"b0c7d675.9f98a8","type":"MySQLdatabase","z":"","host":"127.0.0.1","port":"3306","db":"sensordata","tz":"GMT + 7"},{"id":"3a82b53.88c104a","type":"ui_group","z":"","name":"Khu vực 1","tab":"e070434f.c4a94","order":1,"disp":true,"width":"6","collapse":false},{"id":"e070434f.c4a94","type":"ui_tab","z":"","name":"Biểu đồ","icon":"pie_chart","order":4,"disabled":false,"hidden":true}]

```

---

<div class="post-metadata">

**Author:** ![Andrei](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/andrei/32/10446_2.png) [@Andrei](https://discourse.nodered.org/u/Andrei)\
**Post date:** [2 June 2019 13:42 UTC](https://discourse.nodered.org/t/need-help-with-line-chart/11678/16 "2019-06-02T13:42:42Z")

</div>

Let´s have a look in your data:

```auto
"data": [
    [{ "x": datetemp1, "y":temp1 }],
    [{ "x": datehumi1, "y":humi1 }]
],

```

You have two series and only one point in each series. One point will not draw a line. This is why you don´t see a chart.

I will fake some data to explain. Below has two series (temperature and humidity) with 3 points in each series.

```auto
"data": [
    [{ "x": 1559481514470, "y":30 },{ "x": 1559481524470, "y":20 },{ "x": 1559481534470, "y":40 }],
    [{ "x": 1559481514470, "y":10 },{ "x": 1559481524470, "y":30 },{ "x": 1559481534470, "y":50 }]
],

```

It will display:

![r-01](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/0/0891d82cdba7df573f446d0bac877c06f12a5ea8.png)

Flow testing:

```auto
[{"id":"7ee7e812.55f148","type":"tab","label":"Flow 2","disabled":false,"info":""},{"id":"79a5afb0.61c5b","type":"ui_chart","z":"7ee7e812.55f148","name":"","group":"f27afcb9.528a8","order":1,"width":"6","height":"6","label":"Nhiệt Độ","chartType":"line","legend":"true","xformat":"HH:mm:ss","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":"9999","removeOlderPoints":"500","removeOlderUnit":"604800","cutout":0,"useOneColor":false,"colors":["#1f77b4","#ff8040","#008080","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":600,"y":100,"wires":[[]]},{"id":"912b3820.314f88","type":"function","z":"7ee7e812.55f148","name":"all","func":"\nmsg.payload= [{\n\"series\": [\"Temp\", \"Hum\"],\n\"data\": [\n [{ \"x\": 1559481514470, \"y\":30 },{ \"x\": 1559481524470, \"y\":20 },{ \"x\": 1559481534470, \"y\":40 }],\n [{ \"x\": 1559481514470, \"y\":10 },{ \"x\": 1559481524470, \"y\":30 },{ \"x\": 1559481534470, \"y\":50 }]\n],\n\"labels\": [\"X\", \"Y\"]\n}]\nreturn msg;\n","outputs":1,"noerr":0,"x":370,"y":140,"wires":[["79a5afb0.61c5b","cef26598.922bf8"]]},{"id":"cef26598.922bf8","type":"debug","z":"7ee7e812.55f148","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":590,"y":140,"wires":[]},{"id":"1ab7b2df.d85f5d","type":"inject","z":"7ee7e812.55f148","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":160,"y":140,"wires":[["912b3820.314f88"]]},{"id":"f27afcb9.528a8","type":"ui_group","z":"","name":"Khu vực 1","tab":"551dd698.ab8968","order":1,"disp":true,"width":"6","collapse":false},{"id":"551dd698.ab8968","type":"ui_tab","z":"","name":"Biểu đồ","icon":"pie_chart","order":4,"disabled":false,"hidden":true}]

```

---

<div class="post-metadata">

**Author:** ![mastershot24](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mastershot24/32/8857_2.png) [@mastershot24](https://discourse.nodered.org/u/mastershot24)\
**Post date:** [3 June 2019 09:57 UTC](https://discourse.nodered.org/t/need-help-with-line-chart/11678/17 "2019-06-03T09:57:07Z")

</div>

The data i put in each series is an array of data i selected from my data base "datatemp1" is the array of time and "temp1" is the value array. I put the debug and the result in the picture below it don't show any error but the chart is still empty. ![Untitled](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/1/1659182458367444bc80062dfc2b72d7e874467b.png)

```auto
[{"id":"fb70e207.920b","type":"function","z":"eff85edf.d773b","name":"value","func":"msg.topic = \"SELECT value FROM sensordata WHERE name = 'Temp' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":270,"y":40,"wires":[["333aa491.129cec"]]},{"id":"333aa491.129cec","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":430,"y":40,"wires":[["1d5c4cc0.255883"]]},{"id":"2f02b139.72b73e","type":"function","z":"eff85edf.d773b","name":"value","func":"msg.topic = \"SELECT value FROM sensordata WHERE name = 'Air Humidity' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":270,"y":120,"wires":[["d80d042d.f2f6b8"]]},{"id":"d80d042d.f2f6b8","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":430,"y":120,"wires":[["e392ec04.b09e8"]]},{"id":"6f623de9.671e04","type":"ui_chart","z":"eff85edf.d773b","name":"","group":"3a82b53.88c104a","order":1,"width":"6","height":"6","label":"Nhiệt Độ","chartType":"line","legend":"true","xformat":"auto","interpolate":"linear","nodata":"","dot":false,"ymin":"0","ymax":"90","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"86400","cutout":0,"useOneColor":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":true,"outputs":1,"x":1140,"y":60,"wires":[[]]},{"id":"88cc3ae4.73ba48","type":"function","z":"eff85edf.d773b","name":"all","func":"var datehumi1 = flow.get(\"datehumi1\");\nvar humi1 = flow.get(\"humi1\");\nvar datetemp1 = flow.get(\"datetemp1\");\nvar temp1 = flow.get(\"temp1\");\n\nmsg.payload= [{\n\"series\": [\"A\", \"B\"],\n\"data\": [\n [{ \"x\": datetemp1, \"y\":temp1 }],\n [{ \"x\": datehumi1, \"y\":humi1 }]\n],\n\"labels\": [\"\"]\n}]\nreturn msg;","outputs":1,"noerr":0,"x":910,"y":100,"wires":[["6f623de9.671e04","9d8dba1.5394848"]]},{"id":"1d5c4cc0.255883","type":"function","z":"eff85edf.d773b","name":"SQL Query","func":"var temp1=msg.payload;\nflow.set(\"temp1\",temp1);\nreturn msg;","outputs":1,"noerr":0,"x":630,"y":40,"wires":[["88cc3ae4.73ba48"]]},{"id":"e392ec04.b09e8","type":"function","z":"eff85edf.d773b","name":"SQL Query","func":"var humi1=msg.payload;\nflow.set(\"humi1\",humi1);\nreturn msg;","outputs":1,"noerr":0,"x":630,"y":120,"wires":[["88cc3ae4.73ba48"]]},{"id":"9d8dba1.5394848","type":"debug","z":"eff85edf.d773b","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":1130,"y":100,"wires":[]},{"id":"4f5750ba.fb25c","type":"function","z":"eff85edf.d773b","name":"datetime","func":"msg.topic = \"SELECT datetime FROM sensordata WHERE name = 'Temp' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":280,"y":80,"wires":[["cbabecd.553711"]]},{"id":"cbabecd.553711","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":430,"y":80,"wires":[["2f65d719.695088"]]},{"id":"2f65d719.695088","type":"function","z":"eff85edf.d773b","name":"SQL Query","func":"var datetemp1=msg.payload;\nflow.set(\"datetemp1\",datetemp1);\nreturn msg;","outputs":1,"noerr":0,"x":630,"y":80,"wires":[["88cc3ae4.73ba48"]]},{"id":"5dca2d1e.adfa64","type":"function","z":"eff85edf.d773b","name":"SQL Query","func":"var datehumi1=msg.payload;\nflow.set(\"datehumi1\",datehumi1);\nreturn msg;","outputs":1,"noerr":0,"x":630,"y":160,"wires":[["88cc3ae4.73ba48"]]},{"id":"c88d09cc.0e77d8","type":"function","z":"eff85edf.d773b","name":"datetime","func":"msg.topic = \"SELECT datetime FROM sensordata WHERE name = 'Air Humidity' AND node = '1'\";\nreturn msg;","outputs":1,"noerr":0,"x":280,"y":160,"wires":[["a9dbf147.31aa8"]]},{"id":"a9dbf147.31aa8","type":"mysql","z":"eff85edf.d773b","mydb":"b0c7d675.9f98a8","name":"sensordata","x":430,"y":160,"wires":[["5dca2d1e.adfa64"]]},{"id":"68a5a72a.917bc8","type":"inject","z":"eff85edf.d773b","name":"Node 1","topic":"","payload":"","payloadType":"date","repeat":"10","crontab":"","once":true,"onceDelay":0.1,"x":110,"y":80,"wires":[["fb70e207.920b","2f02b139.72b73e","70afd92d.e05238","4f5750ba.fb25c","c88d09cc.0e77d8"]]},{"id":"b0c7d675.9f98a8","type":"MySQLdatabase","z":"","host":"127.0.0.1","port":"3306","db":"sensordata","tz":"GMT + 7"},{"id":"3a82b53.88c104a","type":"ui_group","z":"","name":"Khu vực 1","tab":"e070434f.c4a94","order":1,"disp":true,"width":"6","collapse":false},{"id":"e070434f.c4a94","type":"ui_tab","z":"","name":"Biểu đồ","icon":"pie_chart","order":4,"disabled":false,"hidden":true}]

```

---

<div class="post-metadata">

**Author:** ![Andrei](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/andrei/32/10446_2.png) [@Andrei](https://discourse.nodered.org/u/Andrei)\
**Post date:** [3 June 2019 10:41 UTC](https://discourse.nodered.org/t/need-help-with-line-chart/11678/18 "2019-06-03T10:41:54Z")

</div>

The best information you can provide at this point is an example of the data generated.

Can you possibly copy the array that is generated using the debug node and post here for our analysis?

As you probably know you can copy the data (if it is not too large) using the \>\_ icon in the debug node.

![r-01](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/f/f51b781d0180e244bbf3ca186c20f2a4d25c63a6.png)

---

<div class="post-metadata">

**Author:** ![mastershot24](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mastershot24/32/8857_2.png) [@mastershot24](https://discourse.nodered.org/u/mastershot24)\
**Post date:** [3 June 2019 11:47 UTC](https://discourse.nodered.org/t/need-help-with-line-chart/11678/19 "2019-06-03T11:47:37Z")

</div>

payload  
payload[0].data[0][0].x[0].datetime  
i don't know if i do it right or not

 ![Untitled](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/8/83b6c519d9aa57f5a1038284a5e6605c9028ae64.png)

> Blockquote[{"series":["A","B"],"data":[[{"x":[{"datetime":"2019-06-03 14:46:53"},{"datetime":"2019-06-03 14:47:04"},{"datetime":"2019-06-03 14:47:15"},{"datetime":"2019-06-03 14:47:26"},{"datetime":"2019-06-03 14:48:10"},{"datetime":"2019-06-03 14:48:21"},{"datetime":"2019-06-03 14:48:38"},{"datetime":"2019-06-03 14:49:05"},{"datetime":"2019-06-03 14:49:28"},{"datetime":"2019-06-03 14:49:44"},{"datetime":"2019-06-03 14:49:55"},{"datetime":"2019-06-03 14:50:34"},{"datetime":"2019-06-03 14:51:07"},{"datetime":"2019-06-03 14:51:41"},{"datetime":"2019-06-03 14:52:08"},{"datetime":"2019-06-03 14:52:19"},{"datetime":"2019-06-03 14:52:52"},{"datetime":"2019-06-03 14:53:03"},{"datetime":"2019-06-03 14:53:31"},{"datetime":"2019-06-03 14:53:42"},{"datetime":"2019-06-03 14:53:53"},{"datetime":"2019-06-03 14:54:15"},{"datetime":"2019-06-03 14:54:26"},{"datetime":"2019-06-03 14:54:59"},{"datetime":"2019-06-03 14:55:10"},{"datetime":"2019-06-03 14:55:49"},{"datetime":"2019-06-03 14:56:00"},{"datetime":"2019-06-03 14:56:17"},{"datetime":"2019-06-03 14:56:28"},{"datetime":"2019-06-03 14:56:56"},{"datetime":"2019-06-03 14:57:23"},{"datetime":"2019-06-03 14:57:34"},{"datetime":"2019-06-03 14:57:45"},{"datetime":"2019-06-03 14:57:56"},{"datetime":"2019-06-03 14:58:07"},{"datetime":"2019-06-03 14:58:19"},{"datetime":"2019-06-03 14:58:35"},{"datetime":"2019-06-03 14:58:57"},{"datetime":"2019-06-03 14:59:08"},{"datetime":"2019-06-03 14:59:19"},{"datetime":"2019-06-03 14:59:30"},{"datetime":"2019-06-03 14:59:41"},{"datetime":"2019-06-03 14:59:53"},{"datetime":"2019-06-03 15:00:15"},{"datetime":"2019-06-03 15:00:26"},{"datetime":"2019-06-03 15:00:37"},{"datetime":"2019-06-03 15:01:43"},{"datetime":"2019-06-03 15:02:05"},{"datetime":"2019-06-03 15:02:17"},{"datetime":"2019-06-03 15:02:32"},{"datetime":"2019-06-03 15:02:47"},{"datetime":"2019-06-03 15:03:40"},{"datetime":"2019-06-03 15:04:02"},{"datetime":"2019-06-03 15:04:32"},{"datetime":"2019-06-03 15:05:10"},{"datetime":"2019-06-03 15:05:25"},{"datetime":"2019-06-03 15:06:03"},{"datetime":"2019-06-03 15:06:18"},{"datetime":"2019-06-03 15:06:56"},{"datetime":"2019-06-03 15:07:11"},{"datetime":"2019-06-03 15:07:56"},{"datetime":"2019-06-03 15:08:11"},{"datetime":"2019-06-03 15:08:26"},{"datetime":"2019-06-03 15:08:56"},{"datetime":"2019-06-03 15:09:41"},{"datetime":"2019-06-03 15:10:19"},{"datetime":"2019-06-03 15:10:34"},{"datetime":"2019-06-03 15:10:49"},{"datetime":"2019-06-03 15:11:04"},{"datetime":"2019-06-03 15:11:34"},{"datetime":"2019-06-03 15:12:12"},{"datetime":"2019-06-03 15:12:27"}],"y":[{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28},{"value":28}]}],[{"x":[{"datetime":"2019-06-03 14:46:53"},{"datetime":"2019-06-03 14:47:04"},{"datetime":"2019-06-03 14:47:15"},{"datetime":"2019-06-03 14:47:27"},{"datetime":"2019-06-03 14:48:10"},{"datetime":"2019-06-03 14:48:21"},{"datetime":"2019-06-03 14:48:38"},{"datetime":"2019-06-03 14:49:05"},{"datetime":"2019-06-03 14:49:28"},{"datetime":"2019-06-03 14:49:45"},{"datetime":"2019-06-03 14:49:55"},{"datetime":"2019-06-03 14:50:34"},{"datetime":"2019-06-03 14:51:07"},{"datetime":"2019-06-03 14:51:41"},{"datetime":"2019-06-03 14:52:08"},{"datetime":"2019-06-03 14:52:19"},{"datetime":"2019-06-03 14:52:52"},{"datetime":"2019-06-03 14:53:04"},{"datetime":"2019-06-03 14:53:31"},{"datetime":"2019-06-03 14:53:42"},{"datetime":"2019-06-03 14:53:53"},{"datetime":"2019-06-03 14:54:15"},{"datetime":"2019-06-03 14:54:26"},{"datetime":"2019-06-03 14:54:59"},{"datetime":"2019-06-03 14:55:10"},{"datetime":"2019-06-03 14:55:49"},{"datetime":"2019-06-03 14:56:00"},{"datetime":"2019-06-03 14:56:17"},{"datetime":"2019-06-03 14:56:28"},{"datetime":"2019-06-03 14:56:56"},{"datetime":"2019-06-03 14:57:23"},{"datetime":"2019-06-03 14:57:34"},{"datetime":"2019-06-03 14:57:45"},{"datetime":"2019-06-03 14:57:56"},{"datetime":"2019-06-03 14:58:08"},{"datetime":"2019-06-03 14:58:19"},{"datetime":"2019-06-03 14:58:35"},{"datetime":"2019-06-03 14:58:57"},{"datetime":"2019-06-03 14:59:08"},{"datetime":"2019-06-03 14:59:19"},{"datetime":"2019-06-03 14:59:30"},{"datetime":"2019-06-03 14:59:42"},{"datetime":"2019-06-03 14:59:53"},{"datetime":"2019-06-03 15:00:15"},{"datetime":"2019-06-03 15:00:26"},{"datetime":"2019-06-03 15:00:37"},{"datetime":"2019-06-03 15:01:43"},{"datetime":"2019-06-03 15:02:05"},{"datetime":"2019-06-03 15:02:17"},{"datetime":"2019-06-03 15:02:32"},{"datetime":"2019-06-03 15:02:47"},{"datetime":"2019-06-03 15:03:40"},{"datetime":"2019-06-03 15:04:02"},{"datetime":"2019-06-03 15:04:32"},{"datetime":"2019-06-03 15:05:10"},{"datetime":"2019-06-03 15:05:25"},{"datetime":"2019-06-03 15:06:03"},{"datetime":"2019-06-03 15:06:18"},{"datetime":"2019-06-03 15:06:56"},{"datetime":"2019-06-03 15:07:11"},{"datetime":"2019-06-03 15:07:56"},{"datetime":"2019-06-03 15:08:11"},{"datetime":"2019-06-03 15:08:26"},{"datetime":"2019-06-03 15:08:56"},{"datetime":"2019-06-03 15:09:41"},{"datetime":"2019-06-03 15:10:19"},{"datetime":"2019-06-03 15:10:34"},{"datetime":"2019-06-03 15:10:49"},{"datetime":"2019-06-03 15:11:04"},{"datetime":"2019-06-03 15:11:35"},{"datetime":"2019-06-03 15:12:12"},{"datetime":"2019-06-03 15:12:27"}],"y":[{"value":78},{"value":78},{"value":77},{"value":77},{"value":78},{"value":79},{"value":79},{"value":80},{"value":80},{"value":80},{"value":80},{"value":80},{"value":80},{"value":79},{"value":79},{"value":79},{"value":79},{"value":79},{"value":79},{"value":79},{"value":79},{"value":79},{"value":79},{"value":79},{"value":79},{"value":79},{"value":79},{"value":79},{"value":78},{"value":78},{"value":78},{"value":78},{"value":78},{"value":77},{"value":78},{"value":78},{"value":78},{"value":78},{"value":78},{"value":78},{"value":78},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":77},{"value":76},{"value":77},{"value":76},{"value":77},{"value":76},{"value":76},{"value":76},{"value":76},{"value":76},{"value":76},{"value":76},{"value":77},{"value":76}]}]],"labels":[""]}]

---

<div class="post-metadata">

**Author:** ![Andrei](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/andrei/32/10446_2.png) [@Andrei](https://discourse.nodered.org/u/Andrei)\
**Post date:** [3 June 2019 14:12 UTC](https://discourse.nodered.org/t/need-help-with-line-chart/11678/20 "2019-06-03T14:12:01Z")

</div>

I told you to copy the data using the icon `>_` but this is not correct. You want to use the other icon that appears on the side.

![r-01](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/9/936b870cc1c1ef98a400b79fe665904b732563ae.png)

The data you shared is the one that is being injected in the ui\_chart?

The ui\_chart will only display the chart if the data respects the expected format where each point is an object with the "x" key holding the date (timestamp format) and the key "y" holding the value.

`{ "x": 1504029632890, "y": 5 }`

Apparently, the data your flow is injecting in the ui\_chart node is not formatted correctly.

[Next page](https://discourse.nodered.org/t/need-help-with-line-chart/11678.md?page=2)