Dynamically Expand Range to Create Chart

Dear all

Please see the attached example.

I have data listed as shown, but need the chart to automatically update whenever a new sales figure is added to the next month.

I know you have to use the OFFSET to create dynamic ranges but I can't get it to work horizontally, only if my data is laid out vertically.

Please can you help?

Thanks

Alis