Using Charts for Communication

First, let me tell you that it is a pleasure for me to write for this blog and share with you part of my knowledge. For the last twelve years I have been working with Excel and during the last five my focus was mainly around data visualization/analysis for managers and tools development for . . . → Read More: Using Charts for Communication

Heat Maps in Excel

A heat map is a graphical representation of data where the values taken by a variable in a two-dimensional map are represented as colors.

A neat example of a heat map constructed in Microsoft Excel can be seen below:

The above diagram represents different categories on the Y-axis with the total revenue for each device . . . → Read More: Heat Maps in Excel

All About Excel Sparklines

Sparklines represent little, word-like graphics which can depict intense information in a short space. Until now, third party utilities existed which could be used to create sparklines in Excel 2000-2007. Now, Microsoft has decided to implement sparklines natively in the new Microsoft Excel 2010.

Here is an example of a sparkline table:

Below you will find the most valuable resources . . . → Read More: All About Excel Sparklines