Dynamic Name range for charts

My humble apologies to the group for providing limited and fragmented information. I have added the table.

However I can not recreate my original table. Additional problem is I can not make Column B labels show up in legend.

So I have 2 distinct issues:

1. Can not get legend to show actual names instead of series #.
2. Can not ignore zeros/blank entries from name column (Column B) so they do not plot on chart AND do not show up in legend. I am assuming a dynamic name range is needed by using offset formula so data range adjusts dynamically.........how to go about that?