# Array in a bar graph over a 24 hour period
**URL:** https://discourse.nodered.org/t/array-in-a-bar-graph-over-a-24-hour-period/76323
**Category:** Dashboard
**Created:** [8 March 2023 21:31 UTC](https://discourse.nodered.org/t/array-in-a-bar-graph-over-a-24-hour-period/76323 "2023-03-08T21:31:17Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Duncan](https://discourse.nodered.org/u/Duncan)
#### Post date: [8 March 2023 21:31 UTC](https://discourse.nodered.org/t/array-in-a-bar-graph-over-a-24-hour-period/76323/1 "2023-03-08T21:31:17Z")
Hi all, I am trying to display an array in a bar graph over a 24 hour period. The array has 2 objects, time (hour) and price. how do i go about this?
thanks !
Here is the output from my function node:
```auto
msg : Object
object
_msgid: "09a0c486c861654e"
payload: array[24]
[0 … 9]
0: object
Time: "2023-03-08T00:00:00"
Price: 73.61
1: object
Time: "2023-03-08T01:00:00"
Price: 71.01
2: object
Time: "2023-03-08T02:00:00"
Price: 70.07
3: object
Time: "2023-03-08T03:00:00"
Price: 83.32
4: object
5: object
6: object
7: object
8: object
9: object
[10 … 19]
[20 … 23]
topic: ""
```
---
### Author:  [@Duncan](https://discourse.nodered.org/u/Duncan)
#### Post date: [8 March 2023 21:32 UTC](https://discourse.nodered.org/t/array-in-a-bar-graph-over-a-24-hour-period/76323/2 "2023-03-08T21:32:52Z")
```auto
// Get the price array from context
var priceArray = flow.get("pArray");
// Create an array of objects with time and price values
var records = [];
for (var i = 0; i < 24; i++) {
records.push({
"Time": new Date().toISOString().slice(0, 10) + "T" + i.toString().padStart(2, "0") + ":00:00",
"Price": Number(priceArray[i])
});
}
// Create the message payload
msg.payload = {
"records": records
};
return msg;
```
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [8 March 2023 21:44 UTC](https://discourse.nodered.org/t/array-in-a-bar-graph-over-a-24-hour-period/76323/3 "2023-03-08T21:44:51Z")
The [Charts documentation](https://github.com/node-red/node-red-dashboard/blob/master/Charts.md) has examples of how you need to format the data.
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [7 April 2023 21:45 UTC](https://discourse.nodered.org/t/array-in-a-bar-graph-over-a-24-hour-period/76323/4 "2023-04-07T21:45:26Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.