Empty data on simple query

Hi All!

I need to use Grafana for simple db queries to show some basic ERP data.

My MS SQL query is very simple:
select "Production Line", "Pallets" from vLiveProduction order by Plant, "Production Line"

The data are pretty straight forward and they display in a table.

I cant make them display in a graph or bar or any plugin i tried to. I must be doing something foundamentally wrong here but i cant see what. Any help?

I AM choosing series in graph but nothing changes. I cant find a way to tell grafana which column is the series and which the value… Tried by naming my columns metric and value but still no luck