OFFSET formula in horizontal way

Hi all,

I've been trying to get the OFFSET formula to work in my worksheet, but no success.
The data is arranged in a horizontal way and I only see examples on sites with the data being aligned in a vertical way.

The data goes like this:

A B C D E
Week: 1 2 3 4
Prio 1: 3 4 5 7
Prio 2: 4 6 8 9

So if I want the graph used for data above to update automatically for week, prio1 and prio2 to the right, what would the formula have to look like?

prio.xlsx

I'm not sure I've understood well what you want to do (please give more details) but I've done the attached.
Can this help ?
AL

Thank you for your reply. I'm afraid that won't help me. The data is already there and I don't want to create any other tables with lookup.
I just want the table to update automatically when I enter new values (see attachment for (crap) example).

Only way I know of doing this is via Offset (or putting everything into data table but that will screw up my layout of graph).

I tried what you said and it somewhat works. Week is on the horizontal axis though and is not automatically updated in the graph when entering new value.
Graph does move a space to the side but the weeknumber is not automatically applied in the graph.