Results 1 to 2 of 2

Side by Side Stacked Column with Secondary Axis Line

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 ...

  1. #1
    New Member
    Join Date
    Oct 2015
    Posts
    5

    Default Side by Side Stacked Column with Secondary Axis Line

    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)

  2. #2
    Board Regular Worf's Avatar
    Join Date
    Oct 2011
    Location
    Rio, Brazil
    Posts
    2,748

    Default Re: Side by Side Stacked Column with Secondary Axis Line

    Excel 2013 / Windows 8.1 (home)
    Excel 2013 / windows 7 (work)
    Read Forum Rules here

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com