Source vs Uses of funds - Excel dashboard

[yaswanth92]

How to best represent the sources vs uses of funds in Excel dashboard? Can someone suggest an innovative way to represent the data?

For example:

Sources of funds:
Senior debt - 60
Sub debt - 30
Equity - 10

Uses of funds:
Capex - 80
Financing fee - 8
Interest - 12

 

[Gregor]

How about a waterfall chart?

See attached

 

[r1c1]

@yaswanth92 Good question. I wrote a blog post about this with 14 different options. Check it out here:

https://chandoo.org/wp/charts-for-source-vs-use-of-funds-data

 

[GraH - Guido]

@r1c1, only 14 alternatives?

 

[r2c2]

@GraH - Guido Show us your creativity and make a few...

 

[GraH - Guido]

r2c2, crea-what? Don't think I can use bikers here

 

[yaswanth92]

How about a waterfall chart?

See attached

Thank you @Gregor for the waterfall chart. It's really helpful.

 

[yaswanth92]

@yaswanth92 Good question. I wrote a blog post about this with 14 different options. Check it out here:

https://chandoo.org/wp/charts-for-source-vs-use-of-funds-data

Awesome work @r1c1 Thank you so much for the blog. I really liked it and it's very helpful. Way to go.