Three Variables - plotted in one graph

[djwhichway]

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.

 

[Andrew Poulsom]

You can put your workbook on a share like Box.com and post the URL.

 

[djwhichway]

https://app.box.com/s/0fathryrhsya8joit9fxn3pgly0ugejg

 

[Andrew Poulsom]

Select A16:C20 and copy it to the clipboard. Right click the Compression chart and choose Paste.

 

[djwhichway]

It just adds the bars so now I have 8 bars. I was trying to keep it at 4 bars per section and add a split within each bar.

 

[Andrew Poulsom]

What do you mean by "a split within each bar"?

 

[djwhichway]

the compression and treating make up the total together of the combined bar of maintence capital. I dont think its possible.

 

[Jon Peltier]

Andrew -

I think the OP wants a Clustered and Stacked Column Chart, but didn't read the link closely enough when you posted it before.

 

[Andrew Poulsom]

Could well be Jon.