Side by Side Stacked Column with Secondary Axis Line

Joined
Oct 29, 2015
Messages
10
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?

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>
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Watch MrExcel Video

Forum statistics

Threads
1,099,093
Messages
5,466,603
Members
406,491
Latest member
amirkhosravi

This Week's Hot Topics

Top