In doing the survey, we will be based on the data submitted by the user to get the final statistical results, if the key data compared with C-ring-phase set of methods displayed on the screen, a sharp contrast, you can make people at a glance (Figure 1). So how does a C-ring work? We use a WPS form to illustrate the case with a specific Life Pressure index survey.
1. Prepare basic data
First we need to arrange the results of the survey data in a WPS table, the results are divided into "pressure", "generalization", "very relaxed" 3 of results, in percentage from small to large order.
Because the chart needs a row and column attribute to support, and only one row of data is not sufficient, we need to arrange another row of data to assist in a percent-complementary form (Figure 2).
Enter complementary data for the secondary line, without requiring manual input or by a function or operation. You can get a complementary negative percentage by first selecting the three data for percent and then dragging it up with the black fill handle in the lower-right corner of the cell. Finally manually remove the front minus sign.
2. Tables into charts
Select a range of cells with 6 percent of data, create a chart by using the menu command insert → chart, type the doughnut chart, and then click Finish (Figure 3).
At this point, we see that the chart created is a graphical representation of 3 sets of basic data versus the secondary data 22. We need to convert it into 2 sets of 33-contrast forms.
3. Chart Form Conversion
Click the "Toggle by Column" Tool button, which is compared to 2 sets of data compared to 3 sets of data. We see that legend 1 represents the data for the secondary column, and Legend 2 represents the data in the Percent column (Figure 4).
But in the final result chart, we don't need a diagram of the secondary column, so we need to remove the secondary column's picture from the diagram. Double-click the 3 graphic elements of the same color as the legend 1, set the border and area fill color of the pattern to none, and then click OK (Figure 5). The 3 diagram parts of the secondary column will disappear from the chart.
4 Chart Landscaping Decoration
At this point, only 3 data illustrations of legend 1 are left on the chart, but these 3 data are shown in the same color, and we need to double click on them and set their color to 3 different colors (such as red, yellow, green).
Finally, delete the legend information and customize the legend. By inserting a text box, add a picture name and text annotation to the corresponding position in the diagram, and it becomes the final style of the picture as shown at the beginning of the article (Figure 1)