|Bissantz SparkMaker - Sparklines for Excel, Word, PowerPoint, and HTML documents||19/12/2006 - 09:15:55|
SparkMaker is an add-in for Microsoft Office that lets you create your own sparklines in Excel, Word, PowerPoint, and HTML documents.
Sparklines, a concept invented by Edward Tufte, compress large amounts of data into intense, word-sized graphics, such as:
A company's revenues over time as a bar chart 5.7 Mio.
An exchange rate over several years as a line 1.30
Survey results as pie charts 70 %
Excel functions for dynamic sparklines
A set of user-defined functions for Excel XP and Excel 2003 lets you generate sparklines that automatically update whenever data has changed. With simple expressions like "=Sparkline(...)", you can create cell-adherent, dynamic sparklines directly in the cells of your Excel sheets. With these in-cell graphics, it is possible to design information-rich, dynamic controlling instruments for your business by adding concise visualization to your reports and analyses.
Two variants of functions for sparklines are provided by SparkMaker: single-color and multi-color sparkline functions. The benefit of single-color functions is that their result is displayed in the same cell in which the function itself is located. However, such functions do not allow to highlight subsections of a sparkline with different colors or display numerical values adjacent to the sparkline. For these purposes, SparkMaker offers multi-color sparkline functions which require two cells: one for the result (your sparkline) and one for the formula.
New sparkline font
SparkMaker makes use of TrueType Fonts to generate sparklines, the so-called Bissantz SparkFonts. We now provide a new line font with unparalleled precision and clarity. It displays sparklines on-screen with high quality even with low resolutions. This font permits you to design information-dense reports and dashboards. Print-outs of sparklines are excellent.
Trend indicators for sparkline functions
Supplementary insight into your data is optionally provided by trend arrows that geometrically depict the course of the figure. You can now use these statistically grounded indicators in your dynamic sparkline functions (multi-color only).
Dynamic reports and dashboards in Excel
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.
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.
The sparklines are generated either from specifically crafted TrueType Fonts (TTF), the Bissantz SparkFonts, or as images. Choose between several sparkline types and styles, add numerical data, customize colors and export your sparklines to popular graphic formats like BMP, GIF, JPG or PNG. The data to be shown in such images can be read from the current document, pasted from the clipboard, or edited in a textbox within the SparkMaker dialog.
SparkMaker Editions - Feature Overview
SparkMaker comes in three different editions with varying features: Free, Basic and Pro. During the trial period (30 days after initial installation) you can experience the full functionality of SparkMaker as it is available in the Pro edition. After the trial version has expired, some features of SparkMaker are disabled. The remaining feature set constitutes the Free edition. You can obtain valid licenses for either edition from the Bissantz Web shop.
Original Location: http://www.bissantz.de/sparklines/sparkmaker.asp
|33877||International Crisis Group - Crisis Group Named in Top Ten Global Think Tanks||tc sales||10/08/2008 - 13:56:37|
|33839||Infoworker's Pro Bundle - The bundle for professional information workers||tc devon km||05/08/2008 - 13:47:35|
|31813||IC Web Site: What's True About Intentional Communities: Dispelling the Myths||tc ecovillage||01/03/2008 - 18:13:46|
|30433||How the TC platform helps you make more money and cut costs||tc sales||17/12/2007 - 10:23:46|
|30358||Microsoft Office Live Workspace - Microsoft Office Online||tc||11/12/2007 - 17:10:08|
|26435||Rapid communication networks less likely to shape individual's behavior||tc||07/11/2007 - 13:23:34|
|26335||The three kinds of platforms you meet on the Internet||internet platform tc||03/11/2007 - 14:47:07|
|23694||Analytical dimensions for online gift giving: 'other-oriented' contributions in virtual communities||tc gift||18/06/2007 - 18:07:21|
|22793||Connexions - Sharing Knowledge and Building Communities||learn tc knowledge||28/04/2007 - 09:10:42|
|22641||United Communities of Spirit - philosophy of community||tc community||17/04/2007 - 10:44:07|
|22393||The Death of the third place and the birth of the virtual community||tc||05/04/2007 - 20:29:04|
|18297||Ecovillage Design Education - Training of Trainers||ecovillage tc||13/07/2006 - 15:45:53|
|18212||Leren over rationele en irrationele processen van organiseren||training organiseren tc||28/06/2006 - 17:30:03|
|17541||Vlaanderen e-werkt - Gratis conferentie Anders Werken 21 november in Brussel||tc||10/04/2006 - 09:44:04|
|16849||CommUnity of Minds : Working Together - David Bohm on Dialogue||dialogue tacit thought tc||20/02/2006 - 21:32:06|
|16255||TCX Review - Creating and maintaining social assets||tcx-review business tc||28/02/2006 - 07:49:06|
|15833||The Global Community : Siddha Yoga Meditation, India ::||tc synergy yoga||14/02/2006 - 17:12:41|