Blog of Calc LLC

Tree map chart uses rectangles to show the data of each component in a hierarchical way. For example, suppose a company sells its products to USA and Canada market. In USA, the clients are in New York City and Chicago etc. In Canada, the clients are in Vancouver and Montreal etc. Like below: To make tree map chart, you should have at least 3 columns of data. You can read the data this way: USA is part of World, New York City is part of World, Canada is part of World, Vancouver is part of Canada etc. In the first row, World is the top level, so cell B1 is blank. The third column is the number of items sold in each region, which is used as size of each rectangle in the tree map chart. When making tree map chart, the order of columns are very strict. However, the order of rows does not matter. You can rearrange the rows in a different way but the tree map chart does not change. 1. Select the data. Click Insert > Charts. Under Chart type, select Tree map chart. 2. Now you get a pretty t...

If you have hierarchical data, you can create beautiful hierarchical charts. For example, in a university, there are students of different majors in departments, and departments in schools. Suppose we have data below, showing number of students in each school, department and major. In this example, we show you how to make treemap chart. The other type of hierarchical chart is sunburst chart. The data is equivalent if all the cells are filled. I like the following format better. 1. Select the data, then click Insert > Charts > Other Charts > Hierarchical . Select Treemap .  2. A nice-looking treemap chart is shown. The blue area shows all engineering students. The orange area shows all business students. Size of each rectangle is proportional to the number of students in each major.