![]() ![]() The graph below shows how you can format the final graph. Step 6: Format the Graph – Thick Bars, Change the Scale, Remove the Legend Click the no-fill for both the low and the high label Format the data series and then go to the no-fill. Step 4: Do the Same thing with the High End Data Labelsĭo the same thing but you can use a different way to format the data labels to get them close to the middle bar Step 5: No Fill the Data Label BarsĬlick on the blue and green series. Then you can format the data labels so that the are close to the red bar. Select the blue area and add data labels. Note that the little red thing in the middle is what will be graphed Step 3: Add Labels You may have to right click and change the row and column. Step 2: Insert a Stacked Bar Graph Using Alt F1Īfter you create the table, select the data and press Alt F1. Note that the low and the high are now just for the labels and the increment is the real item that is graphed. Now, simply repeat the data and put the increment between the high and the low in a separate table as shown below. The data below is an illustrative starting point The example is attached to the button below. In this example I start with a high and a low for an assumed M&A transaction. ![]() To make a football field diagram use the following steps. The increment is what is graphed and the high an low are used to create the data labels. The tricks to make this work is to are to add an increment between the high and the low. The good news is that no macros are necessary. 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.
0 Comments
Leave a Reply. |