861 results for how to swap axis in excel
- All Tutorials
- Video Tutorials
- Quick Tutorials
861 results for how to swap axis in excel
How to convert Excel to PDF02:50
How to convert Excel to PDF
PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....
How to create a scatter chart in WPS Spreadsheet02: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....
How to draw a column chart in WPS Spreadsheet01: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....
How to set Picture Effect in WPS Presentation02: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....
How to create a Form in spreadsheet01:26
How to create a Form in spreadsheet
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. ....
How to set Shape Effect in WPS Presentation02: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 ....
How to apply accounting number format in WPS Spreadsheet00:56
How to apply accounting number format in WPS Spreadsheet
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Counting the amount in areas of finance and accounting is quite necessary. Take this Budgetary sheet as an example. The table's currency symbols and decimal points are badly aligned, which is not convenient for us to consult and calculate. How can we improve it? Select the cells D7-D15. Click Number Format in the Home tab, and select More Number For....
How to group objects in WPS Spreadsheet01:20
How to group objects in WPS Spreadsheet
In the workplace, we sometimes need to adjust the objects in WPS Spreadsheet uniformly. In today's tutorial, we will learn how to group multiple objects in excel.For example, moving the figure in the upper left corner as a whole will separate the header and the content box.To solve this, we can hold down the "Shift" key to select both the header and the content box. Then the ribbon will switch to "Drawing Tools," where you can click "Group." This button can also be found in the sho....