Dashboards and Reporting for Excel Pivot Tables
Dazzle associates with dashboards and insightful reports automatically generated by analyzing data spread over multiple spreadsheets (save time and effort, too).
Excel pivot tables and pivot charts are great tools for one-time analysis of data tables in a single spreadsheet. But, without automation, you can’t use them to share your findings with [...]
June 24, 2009
Tags: consolidate data, dashboard, Excel, pivot charts, reports Posted in: Charts, dashboards, excel pivot tables 
No Comments
Nifty Utility to Create Clustered and Stacked Column Charts
If you’re trying to cram a 3-dimensional set of comparative data points into a single chart, you should consider a clustered and stacked column chart.  For example, if you want to compare sales across 3 regions, 2 groups, and 4 quarters, that’s a 3-dimensional comparison that requires a chart that looks like this:
For Excel users, this is not a [...]
January 26, 2009
Tags: Charts, Excel, stacked column Posted in: Charts No Comments