I often use the slide below in quarterly investor presentations for large corporates. How to give a quick overview of the key financials in one chart?
This chart is an example of why often a "manual" chart is much more powerful than a simple copy and paste from Excel:
- The chart contains values that can differ vastly in range: sales can be 100s of billions of dollars, EPS can be less than a dollar. Margins are percentages, not dollars.
- Despite this, I forced the Q1 column of each of these values to be the same. In the underlying spreadsheet, they will all say "100". The other values are calculated as a relative value compared to this 100. To accentuate this in the chart, I connected the left columns with a dotted line.
- As a result, all labels in the chart need to be filled out by hand, the same for the growth bubbles which I placed over the columns (again a bit unusual)
You can download this KPI chart from the template store.