147 results for how to change scale on excel graph
- All Tutorials
- Video Tutorials
- Quick Tutorials
How to crop the picture in a table01:30
How to crop the picture in a table
Sometimes we need to crop the picture into the shape we want after inserting it. So how can we do that? Take this table as an example. We have inserted a picture of the clothes on the table, but the picture is a little large. We need to crop it into the right shape and size. Click on the picture to jump to the Picture Tools tab. Click the Crop drop-down button, and we can see two options. Here we select Crop by Scale to adjust its scale. We select the 1:1 scale to crop the picture. No....
How can we resize the images in Documents01:21
How can we resize the images in Documents
When using WPS Writer, we often insert pictures for instructions. Sometimes we need to resize the picture precisely. How can we adjust the size of picture in a document? In this document, insert a picture and adjust its layout. For example, we can change the layout to Behind Text in the Wrap Text catalog. Then, set the font color as white. Then right-click the image and choose More settings. In the pop-up interface Layout, click the Size tab. If we need to scale the picture proportion....
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 change case in Excel
There are three relevant functions can help a lot. Here we take a name table as an example.1. UPPER functionWe can use this function to convert the whole word to upper case. Enter the formula “=UPPER(A2)”, and drag the mouse to fill the following cells. 2. LOWER functionWe can use this function to convert the whole word to lower case. Enter the formula “=LOWER(B2)”, and drag the mouse to fill the following cells. 3. PROPER functionWe can use this function to convert the first letter t....
Print out tables02:43
Print out tables
In the previous video, we learned how to set the table page and the header and footer of the table. And this video will teach us how to print out tables. In our daily work, we often need to use the print function. In the quick access toolbar, we can click Print Preview and then click the Settings button to pop up the Print dialog. Before printing, we need to make sure that the computer is connected to the printer. If we need to print two copies of the spreadsheet document, we can chec....
How to add a cover page in WPS Writer00:47
How to add a cover page in WPS Writer
WPS Writer is a terrific tool for adding a cover to your resume or report if you want them to have a great impression on others. How can we add a cover page to a document?We can turn to Cover Pages in the Section tab or click Cover Pages in the Insert tab. Click the Cover Pages button in the drop-down list, and we can see that there are different kinds of covers to choose from, including Business, Resume, Thesis and Transverse. After selecting the cover page, we can change the build-i....
Make a ranking bar chart01:58
Make a ranking bar chart
The bar charts use bars with the same width to indicate the amount of data. Therefore, we can compare data intuitively. By using a bar chart, it will be convenient for us to compare the differences between data.Take this table as an example. This is the data of cumulative confirmed COVID-19 cases on April 9, 2020. If we want to see the difference in confirmed cases between countries more intuitively, we can use a bar chart.1. Click any cell in the data area.2. Click the Insert tab.3. T....
How can we set margins in WPS Writer02:16
How can we set margins in WPS Writer
Margins are the white space between the contents of the document and the edge of the page. When typesetting and printing, we can adjust the margins according to the content layout. Take this document as an example. Click the Margins button in the Page Layout tab. Then we can select some regular page margins in the selection list. If we want to customize the page margins, just click Custom Margins in the Margins selection list, then the Page Setup dialog box will pop up. We can also s....