- #Football x and o sheets how to#
- #Football x and o sheets series#
- #Football x and o sheets download#
To make the right bars into no fill, you select the data series and then clicking on the no fill option. The first thing to do is just to make the bars at the left and the right into no fill bars. Now you can start cleaning up the graph with the bar chart and putting in the data labels. The graph in the screenshot above does not look too good. With the stacked bar, that has the low range, the increment and the high range.
In the bar chart I select the second option that is a stacked bar. Then I have changed the chart type and made it a bar chart. In the example illustrated on the screenshot below, I have selected the second table from the above screenshot and pressed ALT, F1 to insert the graph on the same page. Once you have the table, the next step is to make a graph from the three columns that will not look very good but will be the outline and provide the basis for the final graph.
#Football x and o sheets how to#
The screen shot below demonstrates how to set up this key part of the process of making a little table. The big deal is to create the increment that is calculated as the difference between the high case and the low case. The low range is for the data label that goes on the left and the high range is for the data label that goes on the right. Once you have the data with the different valuation techniques and the ranges for each technique, the key step is create a table with the low range, the increment and the high range. As usual, I have also included a video describing the process.Įxcel File with Step by Step Description of How to Create Football Field Diagram and Include Labels Subsequent screenshots on this page demonstrate how to get from the values in a table of value ranges to the football field diagram with data labels. The screenshot shows above illustrates the end of the process that includes the bars and the tricky to implement labels.
#Football x and o sheets download#
The file that you can download from clicking on the button below walks through the steps for creating a football field diagram from the assumed ranges in values from different methods shown in the screenshot below. The good news is that no macros are necessary.Ī football field diagram and the link to see how to make a football field diagram is illustrated below: Putting labels on the football field involves adding a separate series to make spaces and it can be painful. The step by step description and the video below demonstrate how you can construct such a flexible football field diagram that includes the valuation amounts as labels on the graphs. But the problem comes when you put labels on the valuation bars in the chart from different methods. Making the bar chart with the range of values is pretty simple. Making a basic football field graph is can be accomplished with the bar chart selection in excel. While the name is irritating, the idea of presenting different valuation approaches is pretty good because a football field diagram shows that different valuation techniques can be used and that it is naive to believe a single valuation amount is reasonable. For example, the range in valuation from low and high comparable P/E ratio’s is compared with the range in value from a DCF method with different WACC assumptions. A football field graph is a pretty silly name used to present alternative valuation techniques with different ranges for M&A analysis. On this page I walk through how to create a football field diagram. Football Field Graphs (American Football) to Illustrate Ranges in Value
0 kommentar(er)
