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.

Thanks a lot Andy,

What would be my next steps in this process?

Thanks
Daniel

Sorry I wasn't clear,

I meant once i've ammended the data how do I get the exisitng pivot table to find the new data?

This doesnt seem to be an option in Excel 2010. When i right click on the pivot table i get an "options" menu, however change data source is not available???

Having a stupid moment, sorted it!

Thanks for you help