Ther's a few BI tools saying they can do fancy graphs like Sparkline sand Bullet Graphs but ExcelUser shows you how you can do them in Excel and therefore dynamically off TM1 data.
http://www.exceluser.com/explore/bullet.htm
http://www.exceluser.com/dash/sparkintro.htm
There may be a small fee involved in some of them.
