162 results for how to swap x and y axis in excel
- All Tutorials
- Video Tutorials
- Quick Tutorials
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 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 set the text effect of slides02:53
How to set the text effect of slides
When we use WPS presentation to make slides, text effects can be added to make the document more aesthetic and better-designed. So how can we set text effect?Take this slide as an example, select the text content, click the Text Tools tab at the top, then click Text Effects and select More Text Effects. Next, I will demonstrate different effects one by one. · 1. ShadowAdding a shadow effect to the text can make it more stereoscopic.Select the text and click SHADOW, where you can choose....
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 insert a background image and print it out in WPS Spreadsheet01:31
How to insert a background image and print it out 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. Sometimes, background images are nice-to-have if we are to beautify the table. Today, we will learn how to add a background picture and print it out. First, head to the Page Layout tab, click the Background button and select the desired images. Note: The inserted image, either too big or too small, is inappropriate. Here is a smart way for adjusting tho....
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 can we draw a line chart02:36
How can we draw a line chart
The line chart is mainly used to show the trends in data and is also one of the most commonly used chart styles at work. This table shows the number of newly hired employees and the number of employees who resigned from the company from 2000 to 2021. So how can we quickly generate a line chart on this? 1. Select all the data in column B. 2. Click the Chart button in the Insert tab, and choose the Line option. In this way, we can get a simple line chart.If we modify the data in the data....
How to change the page orientation00:48
How to change the page orientation
To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. Changing the orientation of printing paper is mostly necessary for our daily work. How can we set them in landscape or portrait orientation? In this table, we want to set the paper orientation and print it out. First, head to the Quick Access Toolbar in the upper left corner of the interface, then click Print Preview. If we want to print the table horizontally, click the Landscape butt....