Three Variables - plotted in one graph

djwhichway

New Member
Joined
Jan 23, 2015
Messages
9
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.
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

djwhichway

New Member
Joined
Jan 23, 2015
Messages
9
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.
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Nope. Just copy the data and paste it into a reply.
 

djwhichway

New Member
Joined
Jan 23, 2015
Messages
9
Nope. Just copy the data and paste it into a reply.
Compression & Treating Combined
Type of SpendOriginal 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 SpendOriginal 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

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
 

djwhichway

New Member
Joined
Jan 23, 2015
Messages
9
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.
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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?
 

djwhichway

New Member
Joined
Jan 23, 2015
Messages
9
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,091
Messages
5,466,579
Members
406,490
Latest member
Ankusharma

This Week's Hot Topics

Top