Color coding in treemap diagrams

If I want to display the following data in a treemap diagram, I encounter a problem:

DataView of Values to be shown in Treemap

 

 

 

 

 

 

 

 

 

 

The scaling in the Treemap object is obviously correct. But, in my opinion, the color coding is faulty (or at least not comprehensible/understandable for me).

 

 

 

 

 

 

 

 

 

 

 

 

If a treemap is created from the data table at the Top, the color coding (an alarm is set to negative = red and positive = green) leads to an incorrect visualization.

 

The presentation of positive and negative tends to be correct.
The expression of the color levels (understandable with the negative = red values), leads me however on a wrong track!

 

In the dataview, you can see that the element 07 shows the highest negative deviation. In the treeview object you get the impression that element 05 shows the highest deviation (the red is most intensive)

Following the Dataview, element 07 show show full (red) saturation.

 

So I get wrong hints from the graphical evaluation! No problem if only a small amount of data is displayed.
With extensive evaluation this leads to wrong conclusions!

I conclude from this that the sorting of colors in the tree view is not correct.

 

Has anyone had similar experiences or (better!) a solution to this problem?

Tagged:

Answers

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers

    Hi dirk magerkord,

     

    you might want to have a look at Björn Reuber's inspiration on color coding with saturation in treemaps which you'll find here: Using "desaturate Alerts"/Treemaps with alerts and negative Numbers .

    It might not be the solution to your challenge but it could perhaps lead the right way.

     

    Kind Regards

    Helmut

  • Hello Helmut Heimann,

    You're right! That's a good tip from Björn Reuber ! I'll deal with it!
    In my opinion, however, more a workaround than a real solution to the problem.

     

    Nevertheless, thank you very much!