Sun Chart (Sunburst Chart) Drawing: R Language & Excel

The Sunburst Chart is also called the Sun Chart, a ring-mounted graph, each of which represents the same level of proportional data, and the higher the ring level from the origin, the more the inner circle represents the top level of the hierarchy. In addition to the rings, the Sun map has several ' rays ' that radiate out from the origin, which show the contextual relationships between different levels of data. From the center of the sun, the layers go outward, which can clearly reflect the path of the event, and is used for the path analysis.

The SUNBURSTR package in the R language enables the drawing of the Sun map, install.packages (' Sunburstr '), with its own data visit-sequences.csv Demo:

Install.packages (' Sunburstr ') library (SUNBURSTR) sequence <-read.csv (  system.file (' examples/ Visit-sequences.csv ', Package              = ' sunburstr '),  header = F,stringsasfactors = F) head (sequence) sunburst ( Sequence

　　

Excel 2010 Operation Demo:

The first step is to select Group summary data and insert a doughnut chart.

In the second step, select the doughnut chart and right-click to select your data.

Third step, add data series, select detailed grouping data.

Fourth Step: Add the total amount of data to the sun chart in the third step, then fill in the total data with a pie chart, and finally add the data labels as shown below:

excel2016 in the insert chart with a Sun chart, you can insert the build directly with one click.

Reference Source:

Http://www.360doc.com/content/17/0502/07/35804869_650214788.shtml

Http://blog.sina.com.cn/s/blog_49f78a4b0102wg92.html

Sunburst Chart Drawing: R language & Excel