MiniCharts Features, Sparklines, Excel Dashboards, Heatmaps, Working with Excel charts, Charting in Excel

Minicharts para Excel - Funciones

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 MiniCharts 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.

MiniCharts 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?: MiniCharts are small charts with an intensity of visual distinctions that will improve the visual reading of data making it faster and simple. MiniCharts 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.

Usando Excel y Minichart para categorizar reportes:

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 MiniCharts, inserting these bump charts will be easier and you will be able to see changes in your data immediately.