The configuration for ui-chart (DB2) is very different from the old dashboard. Here is a very basic flow plotting the data:
[{"id":"f6e233f116dc12a1","type":"inject","z":"d84b176e12749a08","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"My Data","payload":"[{\"date\":\"08-02-2025\",\"value\":3.6},{\"date\":\"08-03-202\",\"value\":4.2},{\"date\":\"08-04-202\",\"value\":3.8}]","payloadType":"json","x":702.6506652832031,"y":3493.814262574219,"wires":[["e75b92fb0a46932f"]]},{"id":"e75b92fb0a46932f","type":"ui-chart","z":"d84b176e12749a08","group":"fd6045295841c382","name":"Spreadsheet Data","label":"Spreadsheet Data","order":3,"chartType":"bar","category":"topic","categoryType":"msg","xAxisLabel":"Date","xAxisProperty":"date","xAxisPropertyType":"property","xAxisType":"category","xAxisFormat":"","xAxisFormatType":"auto","xmin":"","xmax":"","yAxisLabel":"Starts","yAxisProperty":"value","yAxisPropertyType":"property","ymin":"","ymax":"","bins":"","action":"replace","stackSeries":false,"pointShape":"circle","pointRadius":4,"showLegend":true,"removeOlder":1,"removeOlderUnit":"3600","removeOlderPoints":"","colors":["#0095ff","#ff0000","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"textColor":["#ffffff"],"textColorDefault":false,"gridColor":["#e5e5e5"],"gridColorDefault":true,"width":6,"height":8,"className":"","interpolation":"linear","x":906.1875,"y":3495.23876953125,"wires":[[]]},{"id":"fd6045295841c382","type":"ui-group","name":"db2 bar wip share","page":"ccc312f7c9d7a917","width":"30","height":1,"order":1,"showTitle":true,"className":"","visible":"true","disabled":"false","groupType":"default"},{"id":"ccc312f7c9d7a917","type":"ui-page","name":"db2 bar wip share","ui":"de5759a313e7ad79","path":"/page26","icon":" ","layout":"tabs","theme":"682b37bffc90cac5","breakpoints":[{"name":"Default","px":"0","cols":"9"},{"name":"Tablet","px":"576","cols":"9"},{"name":"Small Desktop","px":"768","cols":"9"},{"name":"Desktop","px":"1024","cols":"12"}],"order":24,"className":"","visible":"true","disabled":"false"},{"id":"de5759a313e7ad79","type":"ui-base","name":"Node-RED Dashboard DB2","path":"/dashboard","appIcon":"","includeClientData":false,"acceptsClientConfig":["ui-notification","ui-control"],"showPathInSidebar":false,"headerContent":"dashboard","navigationStyle":"fixed","titleBarStyle":"default","showReconnectNotification":true,"notificationDisplayTime":5,"showDisconnectNotification":true,"allowInstall":true},{"id":"682b37bffc90cac5","type":"ui-theme","name":"Rakesh Dark","colors":{"surface":"#097479","primary":"#337278","bgPage":"#000000","groupBg":"#000000","groupOutline":"#337278"},"sizes":{"density":"comfortable","pagePadding":"6px","groupGap":"5px","groupBorderRadius":"1px","widgetGap":"6px"}},{"id":"4c35d499a5db6512","type":"global-config","env":[],"modules":{"@flowfuse/node-red-dashboard":"1.25.0"}}]
This is what the chart looks like:
Take a look at the configuration of the chart. x-axis = date, y-axis = value. Hope this helps.