Football fields are easy to make in excel using the stock chart option. here are the steps of how to make a football field chart in excel: create a table in excel with the range of values. insert a stock chart type called open low high close. set the open and low values as being the same. set the high and close values as being the same. The football field valuation chart is one of the most common slides in an investment banking pitch book. in short, the football field is a floating bar chart in excel that puts several valuation analyses side by side to provide clients with the full context of a company’s value using a variety of methodologies and assumptions.
Part 2 of the football field valuation chart involves adding the company’s current share price as a vertical line, which is much harder than it sounds: step 2.1: create a “dummy series” for the current share price under the main data area, and link to the current share price in the min to max columns and then a dummy number, such as 1,000, followed by 0’s:. Input your valuation data – set up your data with columns for valuation methodology, minimum value, and maximum value. select your data – highlight your input data to feed the football field chart. insert football field chart – go to charts > quick charts > football field. configure settings – select your data in the dialog box. A football field chart is created using the horizontal stacked bar chart in excel. watch the accompanying video to see how to build a quick and simple football field. follow along with the steps yourself using our downloadable football field chart template. The football field chart excel template is an invaluable tool for coaches and team managers who need to quickly and effectively plan and analyze game strategies. this template allows coaches to easily and accurately track formations, formations against certain types of opponents, and even individual player performance.