Shulou(Shulou.com)06/01 Report--

This article mainly explains "what is the TreeMap of sparklines". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "what is the TreeMap of sparklines"?

Composition (TreeMap).

Using the sparklines Mini Chart tool, you can easily create complex charts (HeatMap, TreeMap) in excel that only advanced visualization software can do.

In the sparklines official guidance document, the syntax and parameters of the tree function are given as follows:

The rectangular block area to which the column chart target data will be mapped. (data columns need to be sorted in advance (descending).

The target area where the chart is stored: DestinationRange: here you can use the mouse to select a contiguous range of cells. If only one range of cells is selected, you need to set the chart width and height parameters separately (otherwise the chart will be created in a separate cell).

The color index is the second layer of data information that can be displayed in the chart, which will be mapped on the color depth of the rectangular block of the tree diagram according to the size range of the index.

ColorScale: this parameter requires two columns and is the rule of color mapping, that is, telling the function indicator positive and negative values (Color parameter) color mapping objects in different regions.

LabelRange: is the data indicator label represented by the rectangular block of the tree diagram.

For the two sets of parameters, DestinationRange and HeightPixel/WidthPixel, you only need to define one set, so these two sets of parameters depend on the situation.

For Color parameters, since the grouping rules in ColorScale can only identify integer types, you need to scale up to integers if your Color metric is a percentage or decimal. (but keep the relative size unchanged)

The final results are as follows:

At this point, I believe you have a deeper understanding of "what is the TreeMap of sparklines". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.