thbutterflycollector_
New Member
- Joined
- Oct 29, 2015
- Messages
- 30
- Office Version
- 365
- Platform
- Windows
Hi,
I am trying to convert the following data into a chart and have tried various online sources including Peltier tech but I am not sure whether I'm trying something excel cannot do. Basically I am trying to double stack monthly cost and cumulative cost and then compare this in a seperate stack to monthly value and cumulative value. I am then trying to plot on a secondary axis the cumulative delta profit/loss and the monthly delta profit and loss as a line. Can anyone give me any pointers?
<tbody>
</tbody>
<tbody>
</tbody>
I am trying to convert the following data into a chart and have tried various online sources including Peltier tech but I am not sure whether I'm trying something excel cannot do. Basically I am trying to double stack monthly cost and cumulative cost and then compare this in a seperate stack to monthly value and cumulative value. I am then trying to plot on a secondary axis the cumulative delta profit/loss and the monthly delta profit and loss as a line. Can anyone give me any pointers?
Month | Apr-15 | May-15 | Jun-15 | Jul-15 |
Total Value | 6,778.17 | 19,916.46 | 26,991.68 | 81,030.78 |
Total Costs | 51,549.74 | 47,200.51 | 117,421.80 | 89,421.72 |
Cum. Prelim Value | 6,778.17 | 26,694.63 | 53,686.31 | 134,717.09 |
Cum. Total Costs | 51,549.74 | 98,750.25 | 216,172.05 | 305,593.77 |
Monthly. Delta (P/L) | -(44,771.57) | -(27,284.05) | - (90,430.12) | - (8,390.94) |
Cum. Delta (P/L) | -(44,771.57) | -(72,055.62) | - (162,485.74) | - (170,876.68) |
<tbody>
</tbody>
<tbody>
</tbody>