varied series for graph which adjusts series

Hi

I need to create a graph that updates from a specified range (in yellow)

basically it needs to work by grabbing the data in yellow and then putting in a specified area for the graph (in red). The stuff I have tried leaves empty series which is something I cant get around!

I have been told that I need to use offsets and named ranges, but I have been looking all over the web and cant find anything that works for what I need.

So any help would be great.