Download WPS Office for your device

Do you know how to make an ordinary line chart more special? Today we are going to show you how to make a line chart with fill effects, that is, an area chart.Take this table as an example. This is the dynamic price-earnings ratio data of a certain country over a period of time. It is difficult for us to see the difference between the data. Therefore, we need to use an area chart to show the changes in the dynamic price-earnings ratio index.1. First, we click the Insert tab.2. Click th....

The K-line chart also called the candlestick chart, consists of four elements: close price, open price, high price, and low price, mainly used to display stock, futures, and other transaction data in the financial field. Take this AMZN Stock as an example. Here is the stock data within a month, and we need to create a K-line chart with this data. 1. Select the cell range A2:E24, which contains the four elements: close price, open price, high price, and low price. If you select more cel....

When using WPS Spreadsheets to process data reports, grouping data in proper ways can present data more clearly and boost our productivity. The spreadsheet in this example presents a company's sales performance during the first half of a year. To make it more convenient for data viewing, we can group the data belonging to the same category. 1. Select cells of Column B and Column K. 2. Get into the Data tab, and click the Group button. (Tips: You can also press the shortcut keys Shi....

In daily work, we often need to summarize and calculate some related data. By using the Consolidate feature, we can quickly calculate the data in multiple worksheets. This feature can be also used in Microsoft Office Excel and Openoffice. Now let's learn it together! Take the following table as an example. You can see that there are sales data from different staff. Now we want to count the total sales volume of all employees. 1. Create a summary sheet in Spreadsheet.2. Select cell....

Here are one hundred profiles of new employees, which need to be made into recruitment notices. If you are the HR of this company, how would you do that? The Mail Merge function allows you to handle these 100 notices easily. Take this document as an example. We need to input employees' names, entry time, department, position, and salary.1. Open the table that contains the information of new employees. 2. The information of the five columns will be inserted as Merge Fields. For conv....

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Today, we will learn how to create a Form in WPS spreadsheet, which allows us to input, search and modify the data. Note: If the table contains merged cells, the Form function will be unavailable. · 1. Data inputFirst, click the Data tab and click the Form button. In the pop-up window, the system will automatically take the title row as the field name. ....

We often need to paint various Flowcharts in the office routine. In WPS Writer, we can make flowcharts easily with the Insert Shapes function.There are many kinds of flowcharts. Today, we will give an example to illustrate better. Step one, insert a drawing canvas.Click Insert, then click Shapes and select New Drawing Canvas to add one.A great benefit is that we can drag the canvas directly to move the flowchart.You can drag the position of the canvas only if the canvas is set to a te....

When we edit documents, insert project symbols into appropriate places that could highlight corresponding text contents. In this way, the text would be classified with structured classes. How can we insert project symbols in WPS text? Taking this document as an example, we can see that the difference in font size does not reflect the level of contents very well. If we want to emphasize the relationship between contents, how should we do it? 1. First, choose the corresponding text. 2. ....