A clear representation of C-ring in WPS

Source: Internet
Author: User

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).

Small tips:

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)

Related Keywords:
Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

11.11 Big Sale for Cloud

Get Unbeatable Offers with up to 90% Off，Oct.24-Nov.13 (UTC+8)

Get It Now >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth \$300-1200 USD