Chart/Graph showing volume and price variances by region

Hi,

I am pretty new to charts so any help would be much appreciated.

I have some data relating to crates that are being picked up and transported to different locations in the UK.
Each location has a different price per unit depending on where they are based and the prices can change month on month.

Firstly I need to know how to separate what cost variance is based on volume and what is based on price for the total cost variance.

Secondly I need to be able to show this on a chart/graph to be able to show which region is costing the most month by month based on either volume or by price change.

Hope this makes sense

I have attached a sheet with some data on

Thanks

Hi Adamski911
how you present this will depend a bit on what you are trying to show. In the attached I have given a couple of possible charts. I'm assuming your objective is to show the effect of changes in volume and price by region on total cost/revenue.