shavje
07-07-2014, 05:46 PM
Hi
I am trying to build a cumulative cost curve as described below.
The data is:
Mine A - 10 tonnes production, cost is $30/t
Mine B - 20 tonnes production, cost is $40/t
Mine C - 30 tonnes production, cost is $10/t
X axis - cumulative production with mine name, (i.e. Mine C will be first because it has the lowest cost).
It will also be the widest because it has the largest production.
Next will be Mine A (the bar will be narrower than Mine C because the production is only 10 tonnes, as opposed to 30 tonnes from mine c.
Finally will be mine B because it has the highest cost:
Effectively the end result of the chart should be as per the diagram attached in the following:
11905
Note I created this chart using shapes - it is not an excel chart.
Does anyone know a clever way of creating this chart in excel (whether by Macro or some other way).
Note that when I normally do this chart, there are 100's of data points, so doing it manually is not an option.
Many thanks
I am trying to build a cumulative cost curve as described below.
The data is:
Mine A - 10 tonnes production, cost is $30/t
Mine B - 20 tonnes production, cost is $40/t
Mine C - 30 tonnes production, cost is $10/t
X axis - cumulative production with mine name, (i.e. Mine C will be first because it has the lowest cost).
It will also be the widest because it has the largest production.
Next will be Mine A (the bar will be narrower than Mine C because the production is only 10 tonnes, as opposed to 30 tonnes from mine c.
Finally will be mine B because it has the highest cost:
Effectively the end result of the chart should be as per the diagram attached in the following:
11905
Note I created this chart using shapes - it is not an excel chart.
Does anyone know a clever way of creating this chart in excel (whether by Macro or some other way).
Note that when I normally do this chart, there are 100's of data points, so doing it manually is not an option.
Many thanks