Archive for June, 2009

How to Mass-produce Excel Charts

Problem:
You need charts to help you and your audience see trends and relationships in an Excel spreadsheet’s data. However, there is too much data to show in a single chart. So, you need to create many separate charts for the report (as in the example below).

In addition, the size of the data [...]

June 24, 2009   Posted in: Charts, dashboards, excel charts  No Comments

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: , , , ,   Posted in: Charts, dashboards, excel pivot tables  No Comments