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.

Excel donut chart with multiple levels

Thread starter Worf
Start date Dec 11, 2019
Tags

donut chart nakshatra vba

Overview Reviews (1) Discussion

Worf

Well-known Member

Dec 11, 2019

Worf submitted a new Excel article:

Excel donut chart with multiple levels - shows how to create complex donut charts and format them with VBA

This article shows how to create a donut chart with multiple levels.

Figure 1 shows how to arrange the source data in order to get the layers. If necessary, you can have two starting angles. To accomplish that, use a secondary axis. The chart below has one series on the primary axis and the other two on the secondary. It is a combination chart, and the hole size for the primary series is smaller.

Figures 2 and 3 are extreme examples of this technique, the amphitheatre and the...