Monday, January 03, 2011

Charts and Guages in Excel

As part of some institutional research, I am exploring ways of using common tools to create "dashboards" for data.

Here are some fun links I've discovered which talk about "hacks" to get speedometer style gauges from your data (mainly using MS Excel).

Gauge Chart using XY Scatter Chart (AndyPope.Info)

Gauge Chart by Overlaying a Pie Chart on a Doughnut Chart (chandoo.org)

Other Dynamic Dashboards (chandoo.org)

Excel Template for Gauge (Microsoft.com)

Other Dashboard Ideas (MyExcelTemplates.com)