# Creating a chart in excel csv-file

**URL:** <https://discourse.nodered.org/t/creating-a-chart-in-excel-csv-file/54748>\
**Category:** General\
**Tags:** node-red-dashboard, chart\
**Created:** [5 December 2021 14:47 UTC](https://discourse.nodered.org/t/creating-a-chart-in-excel-csv-file/54748 "2021-12-05T14:47:17Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![SEM](https://avatars.discourse-cdn.com/v4/letter/s/59ef9b/32.png) [@SEM](https://discourse.nodered.org/u/SEM)\
**Post date:** [5 December 2021 14:47 UTC](https://discourse.nodered.org/t/creating-a-chart-in-excel-csv-file/54748/1 "2021-12-05T14:47:17Z")

</div>

Hello everyone,

I'm a student and for a project i have to extract 2 dataflows from a plc (Already done with S7 comm), then i have to make an excel-file with a chart made from those dataflows. and this chart also has to be displayed on the dashboard.

Note: one of the data flows has to be the x-axis.

Can anyone help me cause I don't know where to start.  
Thanks!

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [5 December 2021 15:30 UTC](https://discourse.nodered.org/t/creating-a-chart-in-excel-csv-file/54748/2 "2021-12-05T15:30:25Z")

</div>

Do you need the chart in Excel or just on the Dashboard?

---

<div class="post-metadata">

**Author:** ![SEM](https://avatars.discourse-cdn.com/v4/letter/s/59ef9b/32.png) [@SEM](https://discourse.nodered.org/u/SEM)\
**Post date:** [5 December 2021 15:41 UTC](https://discourse.nodered.org/t/creating-a-chart-in-excel-csv-file/54748/3 "2021-12-05T15:41:46Z")

</div>

One of the two it doesn't matter

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [5 December 2021 16:53 UTC](https://discourse.nodered.org/t/creating-a-chart-in-excel-csv-file/54748/4 "2021-12-05T16:53:04Z")

</div>

The easier of the two is the Dashboard. If you want to do it in Excel, you should set up an xlsx file and use PowerQuery to incorporate the CSV files then do a chart from that. Then all you need to do is to export the new CSV files each time and refresh the data in the xlsx file, the chart will update.

For Dashboard, you can add a UI chart node and feed it the data direct from your inputs.

---

<div class="post-metadata">

**Author:** ![SEM](https://avatars.discourse-cdn.com/v4/letter/s/59ef9b/32.png) [@SEM](https://discourse.nodered.org/u/SEM)\
**Post date:** [5 December 2021 19:27 UTC](https://discourse.nodered.org/t/creating-a-chart-in-excel-csv-file/54748/5 "2021-12-05T19:27:58Z")

</div>

Thanks for your reply!  
But how do i get one of the dataflows to be the x-axis instead of the time?

---

<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:** [3 February 2022 19:28 UTC](https://discourse.nodered.org/t/creating-a-chart-in-excel-csv-file/54748/6 "2022-02-03T19:28:00Z")

</div>

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