Three Variables - plotted in one graph

Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: Three Variables - plotted in one graph

  1. #1
    New Member
    Join Date
    Jan 2015
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Three Variables - plotted in one graph

     
    Hello,

    I am working on a presentation and i have to prepare a graph that shows: Growth capital, Maintenance capital, EBITA and DCF for original 2015 versus new 2015. for each of the Growth capital, maintenance capital, EBITA and DCF - i need each bar broken out by our two departments (compression and treating). HOw do you set it up so you can do that.

    I can do a graph that shows combined totals (compression and Treating). I can do a compression graph and i can do a treating graph. How do you out them all in one nice graph?

    Thank you,

    if you need to see the chart as is if you need to see.

  2. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Three Variables - plotted in one graph

    Welcome to MrExcel.

    Can you post some sample data please?
    Microsoft MVP - Excel

  3. #3
    New Member
    Join Date
    Jan 2015
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Three Variables - plotted in one graph

    Quote Originally Posted by Andrew Poulsom View Post
    Welcome to MrExcel.

    Can you post some sample data please?

    here is a some dummy data.


    -- removed inline image ---


    here is what the chart looks like

    -- removed inline image ---


    I am trying to have it look like this but within each Growth capital. maintenance capital (etc) for original and new - i wanted each bar broken out by treating and compression.

  4. #4
    New Member
    Join Date
    Jan 2015
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Three Variables - plotted in one graph

    did you see the pictures?

  5. #5
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Three Variables - plotted in one graph

    Nope. Just copy the data and paste it into a reply.
    Microsoft MVP - Excel

  6. #6
    New Member
    Join Date
    Jan 2015
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Three Variables - plotted in one graph

    Quote Originally Posted by Andrew Poulsom View Post
    Nope. Just copy the data and paste it into a reply.
    Compression & Treating Combined
    Type of Spend Original 2015 New 2015
    Growth Capital $ 2,000,000.00 $ 2,500,000.00
    Maintenance Capital $ 1,000,000.00 $ 1,000,000.00
    EBITDA $ 5,000,000.00 $ 5,000,000.00
    DCF $ 1,200,000.00 $ 1,000,000.00
    Compression
    Type of Spend Original 2015 New 2015
    Growth Capital $ 1,400,000.00 $ 1,750,000.00
    Maintenance Capital $ 700,000.00 $ 700,000.00
    EBITDA $ 3,500,000.00 $ 3,500,000.00
    DCF $ 840,000.00 $ 700,000.00
    Treating
    Type of Spend
    Original 2015
    New 2015
    Growth Capital $ 600,000.00 $ 750,000.00
    Maintenance Capital $ 300,000.00 $ 300,000.00
    EBITDA $ 1,500,000.00 $ 1,500,000.00
    DCF $ 360,000.00 $ 300,000.00

  7. #7
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Three Variables - plotted in one graph

    Microsoft MVP - Excel

  8. #8
    New Member
    Join Date
    Jan 2015
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Three Variables - plotted in one graph

    i wish i could just post a picture, No, it would be - if you can image this.... the Y axis of course has the number values. the y axis is the Original and new buckets of information. Each bucket has 4 columns (growth capital, maintenance capital, EBITA DCF). Within each column - i wanted to break that out between compression and treating.

  9. #9
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Three Variables - plotted in one graph

    Select from Type of Spend to DCF New 2015 for Compression and insert a column chart. Select from Type of Spend to DCF New 2015 for Treating and copy it to the clipboard. Right click on the chart and choose Paste. Right click the chart and choose Select data. Click 'Switch Row/Column' then OK.

    Is that more like what you want?
    Microsoft MVP - Excel

  10. #10
    New Member
    Join Date
    Jan 2015
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Three Variables - plotted in one graph

      
    do you have an email? i can send you the spreadsheet. i am getting lost talking words and not looking at what the graph does.

User Tag List

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