WSO Elite Modeling Package

  • 6 courses to mastery: Excel, Financial Statement, LBO, M&A, Valuation and DCF
  • Elite instructors from top BB investment banks and private equity megafunds
  • Includes Company DB + Video Library Access (1 year)

Comments (4)

Jun 24, 2014 - 2:35pm

It's a little similar to creating an EBITDA/earnings bridge in that you need to have stacked bars with two components. The bottom part of the stack goes up to just under where the "floating" part of the stack starts.

Create the chart, then select the part of each stack which should be invisible and select no fill/no outline.

Those who can, do. Those who can't, post threads about how to do it on WSO.
  • 1
Jun 24, 2014 - 3:02pm

http://peltiertech.com/Excel/Charts/FloatingColumns.html

In case you've never done what @SSits is saying, there's a tutorial I used a long time ago.

make it hard to spot the general by working like a soldier
Jun 25, 2014 - 7:10am

Thx. a lot. But how can I make them be contiguous to each other? The problem was not to build graph itsel but to make columns adjoined.

And also, as u could notice, there is value on x-axis as well (resourse reserves in the sample). So I don't now how to make it as well. Thx.

Jun 25, 2014 - 9:11am
Start Discussion

Total Avg Compensation

April 2021 Investment Banking

  • Director/MD (9) $911
  • Vice President (35) $364
  • Associates (188) $234
  • 2nd Year Analyst (107) $150
  • Intern/Summer Associate (96) $145
  • 3rd+ Year Analyst (26) $145
  • 1st Year Analyst (392) $132
  • Intern/Summer Analyst (323) $82