Drawing a Bar Chart Within a Bar Chart and Adding a Line

[jsnwahono]

Hi,

I was browsing through excel templates for budgeting and came across this template with a graph that I would like to know how to construct. Here is a picture of the graph:

And the link to the template is: Event Budget Template for Excel

Would really appreciate if anyone could explain to me the steps in moderate detail.

Thanks!

 

[AhoyNC]

See attached links.
https://www.youtube.com/watch?v=wItJCxEMlZY
Use a Thermometer-Style Chart in Your Excel Dashboards - For Dummies