How Excel makes Nightingale rose chart

Florence Nightingale Rose chart making method.

PS: This figure from the appearance of the characteristics of a "radius of the pie chart", originated from Florence Nightingale out of the statistics of the results will not be attention to worry, she developed a colorful chart form, so that the data can be more impressive. This form of chart is sometimes called "Nightingale's Rose," which is a circular histogram.

1, first we open 2013 or more versions of Excel

2, then we casually edit a few sets of data, to 12 rows of 10 as a template, and then select the data

3, click "Insert", select the doughnut chart in the chart area

4, Next we right key chart--set the data series format, in the right window in the circle diameter of the ring to about 3%

5, Next is the focus, we use color fill to do the diagram, click on the ring, and then double-click a separate ring--right--Set the data series format (or directly select the fill)--Choose no fill or pure color fill white, so that one is too slow, so we have to be good at using the F4 key, It'll be easier.

6, this is the final fill color finished after the effect of the picture

7, then we beautify, we right key chart blank place--fill color, choose the background color you want

8, but this because the background color changes lead to the doughnut chart is also the original form, do not worry, this is because the edge of the half ring line is filled with white, so as long as the fill as background color to solve the problem. We choose the circle which has been filled as colorless------------------------------------------------------------

9, below to appreciate the effect of it