Line chart from a list of values? Or other ways to segment and display data

Hi, I have multiple columns with values I want to chart and it doesn’t look like I can easily do it in Coda. So I have used the List() function to get them into a single column, which Coda does like for charts.

How do I get it to plot a chart?

I’ve made a dummy chart to show what I want. To create a line chart I want the horizontal series to be result 1, result 2, result 3, result 4, result 5 with the y axis being the value from 1 to 10.

I have managed to recreate it in Excel pivot chart to give an idea of what I’m hoping to do (mostly, Beef is showing up right but chicken is showing the Sum).