Quickly create dynamic charts

We often use dynamic charts in our practical work. Use the mouse to select different preset items in the slicer. Then the chart will change with the selected item. This video will show you how to quickly create simple dynamic charts. Take this table as an example. We select any cell in the table, click Table under the Insert tab to create a super table, or we can use the shortcut Ctrl+L to quickly open Create Table, and click OK. Get into the Table Tools tab, and click Insert Slicer. I....

How to insert video in WPS Presentation

When making slides, we can make the presentation look more professional by inserting video adequately in slides. So how can we insert videos?Take these slides as an example. Click the Insert tab above, and then click Movie. Here, we can choose Local Video or Link Localvideo. The main difference between them is the way of saving the video files.Please note that: if we choose Link Localvideo to insert a video, once we send the slides to other devices, WPS Presentation may not be able to ....

Use VLOOKUP function to create dynamic charts

In the last video, we introduced the tips for making dynamic charts quickly. And this video will show you how to create dynamic charts with the help of the VLOOKUP function. Some knowledge points such as drop-down lists, VLOOKUP function, and absolute references are involved in making dynamic charts. If you are not familiar with these knowledge points, you're welcome to enter WPS Academy to search for learning. Take this table as an example. We're going to create a dynamic char....

Create simple and intuitive mini charts

The mini chart can help us to compare and analyze data of a row or column. It is very useful when presenting data. So in this video, we are going to show you how to create simple and intuitive mini charts.In Sheet1, we can see Monthly sales of clothing. But we can't visually tell the difference between sales each month. Therefore, we should use the mini chart.1. Click the Insert tab.2. Click the Line buttons.3. Now a Create Sparklines dialog box will pop up.4. Select cells B3:J3 as....

How can we create a drop-down list

How can users quickly enter information in the table according to standard content? Drop-down list can help us to do that. Take this table as an example. Now we need to perfect the data in the “Gender” column. We can easily do that by using the drop-down list. 1. First, select the C2: C16 cell range.2. Then click the Insert Drop-Down List button in the Data tab. 3. We can select the Add choices drop down manually button in the popup dialog box and enter Male in the text box below. 4. T....

How to create a table with one click

Did you know that, when you are using WPS Spreadsheet, you can directly create a table in the original datasheet? The generated table comes with functions such as sorting, filtering, and setting styles, which can save us a lot of time for subsequent operations. For all, easy our work with WPS Spreadsheet like Microsoft Excel. Here are the steps to create a table. Take the sales table in this article as an example. 1. Click the Table button in the Insert tab. (Notes: You can also use th....

Use pivot chart to create a dynamic chart

A pivot chart is a graphical representation of a pivot table, which can clearly and intuitively visualize the data. Suppose we now want to create a pivot chart of the total sales of each branch in the fourth quarter. How can we do that? Take this table as an example. Select any cell in the data area, click the Insert tab, then the PivotChart button. Now select New Worksheet in the popup dialog box, and click OK. After that, we can create an empty PivotTable and an empty PivotChart.In W....

How to insert objects in WPS Presentation

You will be the amazing reporter with WPS Presentation, which could be an alternative to Microsoft PowerPoint. Take this presentation as an example. In order to better explain the contents, I will insert a table into this slide. Click Object in the Insert tab. A dialogue box will pop up, where we could select Create new or Create from file.In the Create new interface, we can select different types of blank documents at the Object type, but we need to edit them manually. In the Create ....