# Multiple line chart from SQL

**URL:** <https://discourse.nodered.org/t/multiple-line-chart-from-sql/28073>\
**Category:** Dashboard\
**Created:** [9 June 2020 18:01 UTC](https://discourse.nodered.org/t/multiple-line-chart-from-sql/28073 "2020-06-09T18:01:08Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![DidierWindey](https://avatars.discourse-cdn.com/v4/letter/d/b9e5f3/32.png) [@DidierWindey](https://discourse.nodered.org/u/DidierWindey)\
**Post date:** [9 June 2020 18:01 UTC](https://discourse.nodered.org/t/multiple-line-chart-from-sql/28073/1 "2020-06-09T18:01:08Z")

</div>

I want to plot 2 lines in chart from 2 SQL datasets.  
When plotting 1 line from 1 dataset, it works fine, but not for 2...

This is the payload. Anyone can help with the sequence ?

[{"series":["solar ="], "data" : zz1 , "labels":[""]},{"series":["actual ="], "data" : zz0 , "labels":[""]}];  
msg.payload = chart3;

thanks

Didier

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [9 July 2020 18:01 UTC](https://discourse.nodered.org/t/multiple-line-chart-from-sql/28073/2 "2020-07-09T18:01:11Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.