Treemap

Treemap is a new chart that comes with Excel 2016, and is used for hierarchical value display in a decreasing order. The values are represented by rectangles, where the largest rectangle represents the largest value, and to the right of it are a smaller rectangles with lower values. This type of chart is convenient to track in the city we have the best turnover, or which item brings the highest revenue …

To make this chart we need a simple table with two columns. In the first we will show the names of the cities, and in the second value of turnover in euros. First, select all the values in the table, then choose Recommended Charts from the Insert ribbon, and after the dialog box opens click on the All Charts tab. In the list of chart types we will find the Treemap option. Choose it, then click OK.
00137-1

After the chart is displayed it should be arranged a bit. Legend should be moved at the bottom of the chart, and title should be added. Also, it would be good to add data labels. As you can see, based on the data, the biggest turnover was achieved in Belgrade, then going to Novi Sad, Subotica, Niš …

00137-2