Tuesday, January 3, 2012

Power of Sparklines in Advent Axys

I recently discovered the amazing work of Fabrice Rimlinger at http://sparklines-excel.blogspot.com and thought of what I believe is a novel way of using the Microsoft Excel integration with Advent Axys reports to potentially achieve a dashboard style report.  This would be far more visually compelling and informative than anything else I have seen in Axys.  For this report, we will just use the standard Axys Portfolio Summary Report and then an Excel macro http://www.box.com/s/9jenb341qmv4iaoeh5uy.  Please also install the appropriate Excel add-in from http://sparklines-excel.blogspot.com.

I know the audience for this will be more limited than my general audience.  I might move these Axys report discussions to my incomplete and defunct http://axysreporting.com site.

For the R lover, I am hoping to also incorporate the unbelievable RExcel from http://rcom.univie.ac.at/.

No comments:

Post a Comment