Dynamic Graphs 2007 (Adding a new column to data)...HELP!?

[Branagan_1]

Hi,

i'm quite new to dynamic charts and offsets....

I have some pricing data associated to a product which i need to add a new column to every time we have a new price. There are several products and several areas where we monitor these products so i need a solution where the graph looks at the product name (i.e like a vlookup) and then adds the data to the graph.

Example of data:

C1 to G1= Product A
I2 to L2 = price
I:L = data
Product B starts at Column M

(In this example i would add a new price in column H by inserting new column, data is arranged like the above on purpose)

I have a friend i could do something with a countif formula and the product name, but i am unsure??

This is my first post, so please let me know if you need any more info.

Hope that makes sense

Thanks in advanced