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.
#CHANGE X AXIS VALUES IN CHART IN EXCEL FOR MAC HOW TO#
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)
