If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Combination Chart: Bars and TreeMap with VBA

Thread starter Worf
Start date Oct 1, 2022

Overview Discussion

Worf

Well-known Member

Oct 1, 2022

Worf submitted a new Excel article:

Combination Chart: Bars and TreeMap with VBA - This article provides code to generate a kind of chart that Excel does not offer

Excel presents a wide variety of charts, but not a hybrid of bars and tree maps. It is not necessary to write code for custom tree maps because a guy named Fabrice Rimlinger already did that when creating the add-in mentioned below.

His source code is not protected so you can look at it after installing the add-in. Here are the main features of my code:

Uses tables as a data source, one of them is shown beneath. The addresses used for this example were: B70:C81, B83:C94...