How the WPS table makes the moving average chart

How to make a moving average chart in a wps table:

We first calculated the average score, in the average of the column input function: =average (D2:D12).

2 but we have to be aware that if we pull down the average score is not the same, because the data in the pull is increased, so we have to lock the data inside, press F4 or add their own $ can also.

Next we're going to insert the chart. This time must select what you need, such as the title must be selected do not select the coordinates do not know what you are.

Select Insert tab Find column shape insert Select the first one is OK.

After the completion of the following we put the average score and the total number of deleted, we click on the average score in the press DELETE key can be.

Next we click the right button to select the Change series chart type into the image settings, we need to change the series name is the average score.

Find the following Setup chart, we modify the second average, we click on the icon type of the inverted triangle Select Line chart, we can see the above changes.

This time you can also pull a little bit wider name to look good, we add data, we click the right button to choose to add data labels

Out of the data tag, we click on a number to select all, in the adjustment of size and color are at the beginning of the tab where we tune the font.

The average points of this line to add data labels when we need to pay attention to, first click a polyline and then click once will be the value of a data label selected this time we add data labels are only one.

The same we set the size of this time we click on the right button inside the Set data label format, the label position set to bottom.

Finally we can also set the width of the column and the size of the data label color and so on are all OK, below we look at the finished chart as shown in the following figure.