This is a discussion on Side by Side Stacked Column with Secondary Axis Line within the Excel Questions forums, part of the Question Forums category; Hi, I am trying to convert the following data into a chart and have tried various online sources including Peltier ...
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)
Excel 2013 / Windows 8.1 (home)
Excel 2013 / windows 7 (work)
Read Forum Rules here