WPS Academy
Free Download
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches

        2498 results for how to swap axis in excel

        • All Tutorials
        • Video Tutorials
        • Quick Tutorials
        • All
        • Spreadsheet
        • Presentation
        • Writer
        • PDF

        2498 results for how to swap axis in excel

        How to draw a column chart in WPS Spreadsheet

        How to draw a column chart in WPS Spreadsheet

        01:46

        How to draw a column chart in WPS Spreadsheet

        A Column chart can help us to visually compare data differences and is also one of the chart styles often used in work.Take this table as an example, how can we quickly compare the differences in sales of each country each country's sales? 1. Click Insert, click Chart, and click Column.2. Click the column with the mouse, and then the editing window will pop up on the right. Then, we can modify the color of the column in FILL&LINE. 3. Click SERIES. We can adjust the gap between the....

        Spreadsheet 16.7K views
        How to set Shape Effect in WPS Presentation

        How to set Shape Effect in WPS Presentation

        02:36

        How to set Shape Effect in WPS Presentation

        Have you ever felt that simply inserting WPS Office's own shape is slightly monotonous? Inserting poorly designed graphics deters us from standing out in work. Learning to use the Shape effect of WPS demonstration can make your slides more professional. Take this slide as an example, select the inserted graphic, click the Drawing Tools tab at the top, then click Shape Effects before clicking More Shape Effects. Next, I will demonstrate different effects one by one. 1. ShadowAdding ....

        Presentation 11.4K views
        How to create a scatter chart in WPS Spreadsheet

        How to create a scatter chart in WPS Spreadsheet

        02:53

        How to create a scatter chart in WPS Spreadsheet

        A scatter chart in WPS Spreadsheet is normally called an X-Y graph. It presents all the data as points on rectangular coordinates, showing the relationships between variables. The scatter plot is a great graphical tool that we often use for statistical modelling. Take this table as an example. This is a set of height and weight data of boys and girls. If we want to observe the relationship between the two variables: height and weight, with the help of a scatter chart, how can we do tha....

        Spreadsheet 10.7K views
        How to use OCR in PDF

        How to use OCR in PDF

        02:12

        How to use OCR in PDF

        Optical character recognition, also called OCR, is practical to extract text information from a picture. It can also maintain the content layout in the source picture. The first example will show you how to extract text from a picture.1. Go to the Tool tab and click OCR.2. In the pop-up dialog, click Screen Capture to take a screenshot of a selected area.3. Choose Extract text only.Then, we can get the text from the dialog on the right-hand side.If you've joined WPS Premium, you ca....

        PDF 21.1K views
        How to download pictures in batches in WPS Writer

        How to download pictures in batches in WPS Writer

        01:04

        How to download pictures in batches in WPS Writer

        When editing a document, we sometimes insert a lot of pictures. We usually back up images in case they get lost.Then, do you know how to download an package of images at a time? For example, in this document, many pictures are inserted into the document, and it is a waste of time to save them one by one. Here I'm going to introduce you a very simple skill. Click the Menu button in the upper left corner, and click the Save as the button to pop up the dialog box.In File Type, select ....

        Writer 9.3K views
        How to set Picture Effect in WPS Presentation

        How to set Picture Effect in WPS Presentation

        02:24

        How to set Picture Effect in WPS Presentation

        You will be the amazing reporter with WPS Presentation, which could be an alternative to Microsoft PowerPoint.Pictures of WPS demonstration can make the slide more professional and appealing. We can also add effects to the pictures to make them cooler. Take this slide as an example, select the inserted pictures, click the Picture Tools tab at the top, then click Picture Effects before clicking More Picture Effects. Next, I will demonstrate different effects one by one. 1.ShadowAdding....

        Presentation 12.4K views
        How to insert calculated fields in PivotTable

        How to insert calculated fields in PivotTable

        01:06

        How to insert calculated fields in PivotTable

        Take this sales performance table as an example. We want to generate a new column, "sales commission" based on this PivotTable. (Tips: Sales commission is equal to sales amount multiplied by 0.08.) So, how do we do that? First, we click the Options tab, and the Fields, Items drop-down button, select Calculated Fields, then the Insert Calculated Field dialog will pop up.In the Name edit box, input "Sales commission". In the Fields area, choose Sales amount. In the Formula edit box, inpu....

        Spreadsheet 12.2K views
        How to sort text in WPS Writer

        How to sort text in WPS Writer

        02:37

        How to sort text in WPS Writer

        When editing documents with WPS Writer, here are three options to sort the data. ONE: Sort by paragraphsTake this document as an example. If we want to sort the data in ascending order, how can we realize it?1. Select the text content.2. Go to Home and click Sort. After that, a dialog box will pop up. 3. Go to Sort by, where we can choose to sort by 'paragraph', 'headings', and 'fields'; in this example, we choose 'paragraph'. We can also set the sortin....

        Writer 42.0K views
        Prev 1 2 3 ... 312 313 Next
        WPS Academy
        Products
        WPS Office for Windows
        WPS Office for Mac
        WPS Office for Android
        WPS Office for iOS
        WPS Office for Linux
        Partners
        Links
        OEM Partners
        Strategic partners

        Follow us

        WPS Office Official Twitter

        WPS Office Official Facebook

        WPS Office Official YouTube