msg.payload is an array of 5 records.
So step #1 is to hover the mouse over that top line that says
object in the debug sidebar -- when the buttons appear on the right, use the second one to "copy" the value of that object to the clipboard.
Step #2: add a
change node downstream from your query node, "Set"
J: and click the ellipsis (
...) next to the expression text box. In the expression editor, paste that msg object into the bottom-left window (overwriting the default data that is shown).
Step #3: now you can write a JSONata expression that will convert your query results array into the data you need for the charts -- something like this should be close (paste it into the upper window):
Step #4: stare with open-mouth as your chart data appears in the bottom-left output window ;*)
Step #5: save the
change node settings, and wire it to your chart node...