Motion Charts and Dynamic Risk Maps

Article by Prof. Hernan Huwyler, MBA, CPA, CAIO
AI GRC Director | AI Risk Manager | Quantitative Risk Lead
Speaker, Corporate Trainer and Executive Advisor

Top 10 Responsible AI and Risk Management by Thinkers360

 

There is an increasing interest in motion charts (Gapminder by Prof. Hans Rosling, motion bubble charts by MicroStrategy). Fortunately, creating motion charts in Excel is easy. I am sharing a motion chart to show how risks evolve in several periods. This worksheet can be used to present risk mapping results.

You can download my demo worksheet from here:
MS Office 2007 http://www.box.net/shared/zvq3c4days
MS Office 2003/97 http://www.box.net/shared/dg1zrzystl


The worksheet contains a risk map with 6 risk categories (populated with mock data). The chart can be animated by clicking on play or using the bar to display the risk changes in frequency (axis X), impact (axis Y) and exposure (bubble size). The worksheet contains a macro to increment the displayed period and a linked table to feed the chart.

I think that the result is very impressive, especially considering that only MS Excel is needed.

Ad: A nice page to recommend about Cutting-edge charts and dashboards
http://www.microstrategy.com/dashboards/