Dynamic Named Ranges on Graphs referencing separate columns

[scraffa]

Ok, this is a little bit technical but I have always seemed to find a pro on these forums with some advice!

I'm making a graph whose x/y axis needs to auto-populate without any extra spaces. I've been using dynamic ranges in order to try and have it select down to the last non-blank entry.

I've got it working for text, however I can't get it working for numbers.

I need it to start on the second cell down of the A column for the text so I'm using this and it's working for my x Axis, which is job positions.
=OFFSET('Position'!$A$2,0,0,COUNTA('Position'!$A2:$A2500),1)
For my Y Axis I'm referencing a number that on the same spreadsheet as positions (but separate from the graph). Right now I'm using:
=OFFSET('Position'!$L$2,0,0,MATCH(1E+306,'Position'!$L2:$L2500,1),1)

Once I plug that range in for my Y axis, the whole thing messes up. Why is this? There is the same amount of entries in each column. Is there a way for me to just have it select the same amount of numbers as the amount of positions that I'm pulling? Maybe with a count statement or something.. So confused. Please help!

Thank you!

 

[scraffa]

No matter what I do the series values keeps showing as "={0}"