Bissantz SparkMaker - Sparklines in Excel reports and dashboards

SparkMaker is ideal to create dynamic reports and dashboards in Excel. It automatically updates sparklines in your Excel templates whenever your data changees and compresses a large amount of data into a very restricted real estate on your screen.

Below, an example of a monthly sales report features net revenues for several product categories and sparklines are used to show the history of the last twelve months of revenues. This report clearly illustrates that notebook sales have decreased significantly and require management attention.

Financial report
Sales report in Excel with sparklines

Easily integrate more than 200 data values in reports such as the financial overview example. For each figure a sparkline precedes the value for the current month (June 2006). The history of the last 18 months for each of the monthly indicators is illustrated with multi-color bar sparklines as in-cell graphs.

Financial report created in Excel with Bissantz SparkMaker

For advanced dashboard design in environments such as process monitoring sparklines are an innovative feature to create intuitive cockpits. In the production example approximately 300 measurements taken from various process steps are presented by using line and bar diagrams: performance indicators for incoming orders, material stocks and production output are depicted. This idealized form of a dashboard is for instance suitable for a plant manager, while additional details and more frequent updates would be required for production managers. Be creative and design your own dashboards on the fly with Bissantz SparkMaker.

Production dashboard
Production controlling dashboard for daily monitoring

Feature list

Supports various sparkline types: bars, lines, winner/loser (whiskers), pies
Creates sparklines directly in your Excel, Word, and PowerPoint documents
Generates sparklines either textually using TrueType Fonts or as vector-based images (Enhanced Metafile Format)
User-defined functions for dynamic sparkline updates in Excel XP, 2003 and 2007
Flexible scaling of sparklines
Additional statistical information: standard deviation, trend
Multiple formatting options, like color and landmark values
New: now also available in sparkline functions
Allows for high quality print-outs
Exports to popular bitmap image file formats: BMP, GIF, JPG, PNG, TIFF
Supports Microsoft Office 2000, Office XP, Office 2003 and Office 2007

Compare editions