Using column values with quickcharts

Can someone help me add a date column into my quickcharts title? I can’t seem to get the concatenate() formula quite right with the quickcharts link.

This is what my chart looks like now, I want to have the column value of the date replace “Daily Energy Mix”.
image

Here is the quickcharts code… I know it’s long, the part I’m having trouble with is in bold towards the end. I’d really appreciate some help.
"https://quickchart.io/chart?c={ type: 'line', data: { labels: [ '12:00 AM', '12:15 AM', '12:30 AM', '12:45 AM', '1:00 AM', '1:15 AM', '1:30 AM', '1:45 AM', '2:00 AM', '2:15 AM', '2:30 AM', '2:45 AM', '3:00 AM', '3:15 AM', '3:30 AM', '3:45 AM', '4:00 AM', '4:15 AM', '4:30 AM', '4:45 AM', '5:00 AM', '5:15 AM', '5:30 AM', '5:45 AM', '6:00 AM', '6:15 AM', '6:30 AM', '6:45 AM', '7:00 AM', '7:15 AM', '7:30 AM', '7:45 AM', '8:00 AM', '8:15 AM', '8:30 AM', '8:45 AM', '9:00 AM', '9:15 AM', '9:30 AM', '9:45 AM', '10:00 AM', '10:15 AM', '10:30 AM', '10:45 AM', '11:00 AM', '11:15 AM', '11:30 AM', '11:45 AM', '12:00 PM', '12:15 PM', '12:30 PM', '12:45 PM', '1:00 PM', '1:15 PM', '1:30 PM', '1:45 PM', '2:00 PM', '2:15 PM', '2:30 PM', '2:45 PM', '3:00 PM', '3:15 PM', '3:30 PM', '3:45 PM', '4:00 PM', '4:15 PM', '4:30 PM', '4:45 PM', '5:00 PM', '5:15 PM', '5:30 PM', '5:45 PM', '6:00 PM', '6:15 PM', '6:30 PM', '6:45 PM', '7:00 PM', '7:15 PM', '7:30 PM', '7:45 PM', '8:00 PM', '8:15 PM', '8:30 PM', '8:45 PM', '9:00 PM', '9:15 PM', '9:30 PM', '9:45 PM', '10:00 PM', '10:15 PM', '10:30 PM', '10:45 PM', '11:00 PM', '11:15 PM', '11:30 PM', '11:45 PM'], datasets: [ { label: 'Production', backgroundColor: 'rgba(145, 170, 138, .75)', borderColor: 'rgb(145, 170, 138)', borderWidth: 3, pointRadius: 0, data:["&[Daily Production Ref].[0:00]&","&[Daily Production Ref].[0:15]&","&[Daily Production Ref].[0:30]&","&[Daily Production Ref].[0:45]&","&[Daily Production Ref].[1:00]&","&[Daily Production Ref].[1:15]&","&[Daily Production Ref].[1:30]&","&[Daily Production Ref].[1:45]&","&[Daily Production Ref].[2:00]&","&[Daily Production Ref].[2:15]&","&[Daily Production Ref].[2:30]&","&[Daily Production Ref].[2:45]&","&[Daily Production Ref].[3:00]&","&[Daily Production Ref].[3:15]&","&[Daily Production Ref].[3:30]&","&[Daily Production Ref].[3:45]&","&[Daily Production Ref].[4:00]&","&[Daily Production Ref].[4:15]&","&[Daily Production Ref].[4:30]&","&[Daily Production Ref].[4:45]&","&[Daily Production Ref].[5:00]&","&[Daily Production Ref].[5:15]&","&[Daily Production Ref].[5:30]&","&[Daily Production Ref].[5:45]&","&[Daily Production Ref].[6:00]&","&[Daily Production Ref].[6:15]&","&[Daily Production Ref].[6:30]&","&[Daily Production Ref].[6:45]&","&[Daily Production Ref].[7:00]&","&[Daily Production Ref].[7:15]&","&[Daily Production Ref].[7:30]&","&[Daily Production Ref].[7:45]&","&[Daily Production Ref].[8:00]&","&[Daily Production Ref].[8:15]&","&[Daily Production Ref].[8:30]&","&[Daily Production Ref].[8:45]&","&[Daily Production Ref].[9:00]&","&[Daily Production Ref].[9:15]&","&[Daily Production Ref].[9:30]&","&[Daily Production Ref].[9:45]&","&[Daily Production Ref].[10:00]&","&[Daily Production Ref].[10:15]&","&[Daily Production Ref].[10:30]&","&[Daily Production Ref].[10:45]&","&[Daily Production Ref].[11:00]&","&[Daily Production Ref].[11:15]&","&[Daily Production Ref].[11:30]&","&[Daily Production Ref].[11:45]&","&[Daily Production Ref].[12:00]&","&[Daily Production Ref].[12:15]&","&[Daily Production Ref].[12:30]&","&[Daily Production Ref].[12:45]&","&[Daily Production Ref].[13:00]&","&[Daily Production Ref].[13:15]&","&[Daily Production Ref].[13:30]&","&[Daily Production Ref].[13:45]&","&[Daily Production Ref].[14:00]&","&[Daily Production Ref].[14:15]&","&[Daily Production Ref].[14:30]&","&[Daily Production Ref].[14:45]&","&[Daily Production Ref].[15:00]&","&[Daily Production Ref].[15:15]&","&[Daily Production Ref].[15:30]&","&[Daily Production Ref].[15:45]&","&[Daily Production Ref].[16:00]&","&[Daily Production Ref].[16:15]&","&[Daily Production Ref].[16:30]&","&[Daily Production Ref].[16:45]&","&[Daily Production Ref].[17:00]&","&[Daily Production Ref].[17:15]&","&[Daily Production Ref].[17:30]&","&[Daily Production Ref].[17:45]&","&[Daily Production Ref].[18:00]&","&[Daily Production Ref].[18:15]&","&[Daily Production Ref].[18:30]&","&[Daily Production Ref].[18:45]&","&[Daily Production Ref].[19:00]&","&[Daily Production Ref].[19:15]&","&[Daily Production Ref].[19:30]&","&[Daily Production Ref].[19:45]&","&[Daily Production Ref].[20:00]&","&[Daily Production Ref].[20:15]&","&[Daily Production Ref].[20:30]&","&[Daily Production Ref].[20:45]&","&[Daily Production Ref].[21:00]&","&[Daily Production Ref].[21:15]&","&[Daily Production Ref].[21:30]&","&[Daily Production Ref].[21:45]&","&[Daily Production Ref].[22:00]&","&[Daily Production Ref].[22:15]&","&[Daily Production Ref].[22:30]&","&[Daily Production Ref].[22:45]&","&[Daily Production Ref].[23:00]&","&[Daily Production Ref].[23:15]&","&[Daily Production Ref].[23:30]&","&[Daily Production Ref].[23:45]&"] }, { label: 'Consumption', backgroundColor: 'rgba(136, 168, 191, .75)', borderColor: 'rgb(136, 168, 191)', borderWidth: 3, pointRadius: 0, data:["&[Daily Consumption Ref].[0:00]&","&[Daily Consumption Ref].[0:15]&","&[Daily Consumption Ref].[0:30]&","&[Daily Consumption Ref].[0:45]&","&[Daily Consumption Ref].[1:00]&","&[Daily Consumption Ref].[1:15]&","&[Daily Consumption Ref].[1:30]&","&[Daily Consumption Ref].[1:45]&","&[Daily Consumption Ref].[2:00]&","&[Daily Consumption Ref].[2:15]&","&[Daily Consumption Ref].[2:30]&","&[Daily Consumption Ref].[2:45]&","&[Daily Consumption Ref].[3:00]&","&[Daily Consumption Ref].[3:15]&","&[Daily Consumption Ref].[3:30]&","&[Daily Consumption Ref].[3:45]&","&[Daily Consumption Ref].[4:00]&","&[Daily Consumption Ref].[4:15]&","&[Daily Consumption Ref].[4:30]&","&[Daily Consumption Ref].[4:45]&","&[Daily Consumption Ref].[5:00]&","&[Daily Consumption Ref].[5:15]&","&[Daily Consumption Ref].[5:30]&","&[Daily Consumption Ref].[5:45]&","&[Daily Consumption Ref].[6:00]&","&[Daily Consumption Ref].[6:15]&","&[Daily Consumption Ref].[6:30]&","&[Daily Consumption Ref].[6:45]&","&[Daily Consumption Ref].[7:00]&","&[Daily Consumption Ref].[7:15]&","&[Daily Consumption Ref].[7:30]&","&[Daily Consumption Ref].[7:45]&","&[Daily Consumption Ref].[8:00]&","&[Daily Consumption Ref].[8:15]&","&[Daily Consumption Ref].[8:30]&","&[Daily Consumption Ref].[8:45]&","&[Daily Consumption Ref].[9:00]&","&[Daily Consumption Ref].[9:15]&","&[Daily Consumption Ref].[9:30]&","&[Daily Consumption Ref].[9:45]&","&[Daily Consumption Ref].[10:00]&","&[Daily Consumption Ref].[10:15]&","&[Daily Consumption Ref].[10:30]&","&[Daily Consumption Ref].[10:45]&","&[Daily Consumption Ref].[11:00]&","&[Daily Consumption Ref].[11:15]&","&[Daily Consumption Ref].[11:30]&","&[Daily Consumption Ref].[11:45]&","&[Daily Consumption Ref].[12:00]&","&[Daily Consumption Ref].[12:15]&","&[Daily Consumption Ref].[12:30]&","&[Daily Consumption Ref].[12:45]&","&[Daily Consumption Ref].[13:00]&","&[Daily Consumption Ref].[13:15]&","&[Daily Consumption Ref].[13:30]&","&[Daily Consumption Ref].[13:45]&","&[Daily Consumption Ref].[14:00]&","&[Daily Consumption Ref].[14:15]&","&[Daily Consumption Ref].[14:30]&","&[Daily Consumption Ref].[14:45]&","&[Daily Consumption Ref].[15:00]&","&[Daily Consumption Ref].[15:15]&","&[Daily Consumption Ref].[15:30]&","&[Daily Consumption Ref].[15:45]&","&[Daily Consumption Ref].[16:00]&","&[Daily Consumption Ref].[16:15]&","&[Daily Consumption Ref].[16:30]&","&[Daily Consumption Ref].[16:45]&","&[Daily Consumption Ref].[17:00]&","&[Daily Consumption Ref].[17:15]&","&[Daily Consumption Ref].[17:30]&","&[Daily Consumption Ref].[17:45]&","&[Daily Consumption Ref].[18:00]&","&[Daily Consumption Ref].[18:15]&","&[Daily Consumption Ref].[18:30]&","&[Daily Consumption Ref].[18:45]&","&[Daily Consumption Ref].[19:00]&","&[Daily Consumption Ref].[19:15]&","&[Daily Consumption Ref].[19:30]&","&[Daily Consumption Ref].[19:45]&","&[Daily Consumption Ref].[20:00]&","&[Daily Consumption Ref].[20:15]&","&[Daily Consumption Ref].[20:30]&","&[Daily Consumption Ref].[20:45]&","&[Daily Consumption Ref].[21:00]&","&[Daily Consumption Ref].[21:15]&","&[Daily Consumption Ref].[21:30]&","&[Daily Consumption Ref].[21:45]&","&[Daily Consumption Ref].[22:00]&","&[Daily Consumption Ref].[22:15]&","&[Daily Consumption Ref].[22:30]&","&[Daily Consumption Ref].[22:45]&","&[Daily Consumption Ref].[23:00]&","&[Daily Consumption Ref].[23:15]&","&[Daily Consumption Ref].[23:30]&","&[Daily Consumption Ref].[23:45]&"] } ] }, options: {legend: { position: 'bottom' },**title: { display: true,fontSize:25, text: 'Daily Energy Mix'** },scales: { xAxes: [{scaleLabel: {display: false, labelString: 'Month'}}], yAxes: [ { id: 'y1', display: true, position: 'left', stacked: false, scaleLabel: {display: true, labelString: 'Energy (kWh)'}}, { id: 'y2', display: false, position: 'right', scaleLabel: {display: true, labelString: 'Performance Index %'}, gridLines: { drawOnChartArea: false} } ] } }}"

What is going to happen if you change above part onto this.

title: { display: true,fontSize:25, text: ‘Daily Energy Mix’, fontStyle:‘normal’}

1 Like

Also reduce font size a bit? as well.

title: { display: true,fontSize:20, text: ‘Daily Energy Mix’, fontStyle:‘normal’}

1 Like

I don’t think I explained it well. I don’t want it to say ‘Daily Energy Mix’ I’d like the title to be the date of the specific row.

You just simply replace that fixed text to colunm variable.

It seems like it would be simple but I’m having a difficult time… these are the variations I’ve tried that don’t work.

title: { display: true,fontSize:25, text: ‘,[Daily Consumption Ref].[Date],’ }

title: { display: true,fontSize:25, text: [Daily Consumption Ref].[Date] }

title: { display: true,fontSize:25, text: ,"&[Daily Consumption Ref].[Date]&"}

…title: { display: true,fontSize:25, text: “&[Daily Consumption Ref].[Date]&” }, scales:…

?