Dashboard Tools for Excel, Sparklines, Excel Dashboards, Heatmaps, Working with Excel charts, Excel Micro charts, Charting in Excel

Dashboard Tools for Excel - Features

New Feature: New Tools

• Audit - Panel :
Now with Dashboard Tools you will be able to analyze and audit models.

-Cell's reference tracker - Panel : Detect and trace references in the cells of your models.
-Model Navigator - Panel .
-Cell watcher - Panel .
-Manage Comments.

• -Links/Names:
-Link Manager : Detect intern and extern references in your models.
-Name Manager : Detect and manage range with names

What is a Sparkline: A sparkline is a type of information graphic characterized by its small size and data density. Sparklines present trends and variations associated with some measurement, such as Annual Sales, Win-Lose, stock market activity, average temperature, etc, in a simple and condensed way.

In Dashboard Tools for Excel you will find a vast amount of sparklines that will improve the visual reading of data making it faster and simple.

What is a heatmap?: A heatmap is a graphical representation of data where the values taken by a variable, in a two-dimensional (or more) map, are represented as colors, size, background, etc.

Mini charts heatmaps can value data with up to 5 different visual values at the same time, making the analysis of great amounts of information fast and easy.

With Heatmaps you can analyze your data with up to 5 dimensions, using:
1. Font Size.
2. Font Color.
3. Font Type.
4. Background Color.
5. Inserting Images.

What is a MiniChart?: Mini charts are small charts with an intensity of visual distinctions that will improve the visual reading of data making it faster and simple. Mini charts are very usefull when a sparkline is too small to represent the information you want to analyse.
These charts are larger than sparklines but smaller than Excel's native graphics for that reason they are ideal for dashboards.

What is a Bump chart?: Bump charts have become quite common of late and are typically used to represent changes in the position of a given number of competing entities over a fixed time duration.

Now, with Dashboard Tools for Excel, inserting these bump charts will be easier and you will be able to see changes in your data immediately.

Special MiniCharts: NEW Special and useful MiniCharts have been added into DashBoard Tools for Excel.