Chart from columns

I have a table with columns like this:

| Date | A | B | C | D | E | F | G | H | I | J |

What I am struggling with is how to add a chart widget that shows a line connecting A-J with the data selected by clicking on a row in the table.

I know the charts like points to be in rows, not columns. I have tried a scatter plot using a custom chart widget with 10 traces, one for each row, but cannot connect the lines. Nor have I been successful in getting a link to work so I can select by clicking a row in the source table.

Any tips or solutions would be awesome!