Now this is interesting. Not only do the XLCubed and MicroCharts Excel add-ins work much better together today than when I originally wrote about combining them, but the publisher of the former has actually acquired the publisher of the latter. This is extracted from the message that went out to MicroCharts users:
Linking XLCubed with MicroCharts connects Dashboards direct to the data and makes them dynamic. It also makes them easier to build as the OLAP Cube can also store the control information for the dashboard as well as the data.
This sounds promising, particularly if microcharts are made available within XLCbubed grids. Formula-mode integration is perfect for dashboard-style reporting but remains limited for dynamically exploring data. More on all this when I’ve had a chance to actually try the “integrated” version.