BonaVista Systems, the maker of MicroCharts 3 sparkline* software for Microsoft Excel and for Microsoft Analysis Services, has announced an Excel Dashboard Competition. The competition is for the best real-world Excel dashboard: supply your own data (suitably obfuscated, of course) and generate a dashboard using only Excel and MicroCharts 3.
*Sparklines are small (word-sized) but information-dense [...]

Dynamic ranges (or “Names”) are commonly used to identify a range of the appropriate length, so that a chart will plot the right number of points. For example, you may want to plot year to date sales, without blanks for the months which are still in the future. The dynamic range uses COUNT or similar [...]