Pivot Tables / Pivot Chart Data

Hello All,

I am fairly new to pivot tables, and have only ever used examples with transactional data.

However, I now have a list of regions and a list of rates, these the rates change monthly. I need this data displayed in a pivot table and eventually a pivot chart for ease of comparison.

I do not know how to achieve what I want! - I've attached an image file of the graph which I need to produce, clearly I would want to add / remove regions as and when necessary, there are onl 2 on there as an example.

Please help!!

Thank you so much.