Excel 2007 : Copy chart, change data source

Hello,
I have some values, and a chart next to them.
I want to copy this "box" 100 times, but i want every chart to be linked
to the values next to it. The problem is that excel will link all this charts with
the values of the first "box".

I attached an example.

Thank you.

seriously...
noone?

Thank you for your answer but it doesn't help me.
Maybe i do something wrong. Can you make my example file work and upload it?
And something else, i don't know much about coding, but it seems that your code has to do with
those 2 particular "boxes", i want to copy this 100 times, so i need a code that refers to any copy of this box i may do.
Thank you.

It worked!

Thanks a lot Andy ! !