Heatmaps Multidimensional
 
Create Heatmaps combining Image, Font, color, backcolor Cell, Text & font type:
 
1 .- First select the Range to Evaluate. For this example the range with the data to evaluate is C18: L28
 
 
2 .- Select the Range with rules table. In this example the selected range is N7: P11
 
 
3 .- Chosee a rule to use
 
 
4 .- Repeat steps 1,2 and 3 until you can complete all rules that you want to use. For this example we have used the following rules: Image, Font, color, backcolor Cell, Text & font type
 
 
5.-Choose the location in your worksheet where Heatmaps will be created. In this example we select the cell C5 and from there and occupying the necessary cells to create the heatmap.
 
 
6 .- Now that we have all the information you need , press the button Execute and the Heatmaps will be created.
 
 
Note:
  • In order to make the tool work correctly, the headings of the columns from their ranges to evaluate must be different.
  • If you will apply images in your rules table, you must take into account that images must have less height and width than the respective cell to permit the image be centered within the borders of the cell.
 
Insert Heatmaps
Refresh
Manage models
Images
Delete Icons