At this stage, your chart should look like this:Ĩ. You may also want to expand the chart to the right, to stretch the valuation ranges. Change the parameters to adjust the value range and to make any other formatting changes as required (for example, to change the font or the number of decimals). Right-click on the X Axis labels and select “Format Axis”. Remove the vertical gridlines by clicking on them and hitting the delete key. At this stage your chart should look like this: Right-click on the floating bar (the red bars in the chart above) and select “Add Data Labels”. Right-click again on the same series and select “Format Data Labels”, then choose “Inside End” for label position. Right-click on the series colored white and select “Add Data Labels”. This has hidden the series, so your chart should show floating bars for each valuation methodology. Select “Fill” as “Solid fill” and choose the color as “White” (to match the chart background), as shown below: Right-click on one of the long bars (the blue bars in the example above) to select the series and choose “Format Data Series”. Select “Series1” (in the pane on the left) and move it down by clicking on the down arrow, as shown below: Right-click on one bar to select the series and choose “Select data”.
The two series should now overlap, so the chart shows only one bar for each valuation method, as in the example below: Under “Series options”, change the “Series overlap” to 100%, as shown below: Right-click on one of the bars, which will select all of the bars of the same color (the “data series”) and select “Format Data Series”, which will open the related menu.
You may also want to include an appropriate title for your chart, or delete it (by clicking on it and hitting the delete key) as necessary.
The legend must be deleted: click on it and hit the delete key. This procedure should have created a bar chart.Ī legend will appear, either to the side of the chart or under the chart, as shown below: Select the data in the table, excluding the first row (where the headers are), then select the Insert menu, select the bar charts group and click on the Clustered bar. Ensure your table does not include any blank rows (if it does, delete them). You can copy and paste this table into Excel to use as an example. The example below shows enterprise values, but it can be used to display share prices or any other valuation measurement. It is applicable to any version of Excel from 2007 to 2016.īelow are the valuation ranges that we need to build the football field for and the associated valuation methodologies.Īrrange the valuation data as a table in Excel. This article shows how to build a football field chart in Excel. “Football field” charts are commonly used to compare the results of different valuation methodologies when applied to a given asset or corporation.
0 kommentar(er)
