Chart is not adjusting

I have a table with set row numbers but data is dynamic. I need my chart to adjust and not plot empty cells however I can't seem to get it right. I experimented with offset and named ranges but with no success. I am looking for some guidance....help!

thank you much!