I blogged about Microcharts last year, but I’ve just heard that version 1.1 has been released and one of the new features is the ability to use them in server-based reporting tools like Reporting Services, as well as in Excel. Take a look at the following two videos which showcase the products:

http://www.bonavistasystems.com/Media/MicroCharts%20Demo/MicroCharts%20Demo.html (client)
http://www.bonavistasystems.com/Media/MicroCharts%20Server%20Components/MicroCharts%20Server%20Components.html  (technical)

 

There’s also a good article on building a dashboard on Adventure Works in Excel 2007 that has some good examples of how to use the new AS cube spreadsheet functions like CubeMember:

 

I see Nick Barclay has already worked out how to use them in PerformancePoint scorecards:

 

Before we get all excited about Excel 2007 as a client tool, I thought I’d also point out this recent post from Marco Russo highlighting a massive drawback with using it on cubes that have time utility dimensions:

What an absolute howler, especially given that I remember Excel 2000 had the same problem and it got fixed in a later release (either XP or 2003) after a lot of complaining. Top priority for SP1 please!