Your browser version is outdated.
To browse WPS Academy normally, we recommend you to upgrade to the latest version of Internet Explorer or try other browsers.
chrome
Chrome
firefox
Firefox
WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches
      • Home
      • Popular
      • excel line graph multiple colors

      12 results for excel line graph multiple colors

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

      12 results for excel line graph multiple colors

      How to fill cells with pure colors, gradient colors, and patterns

      How to fill cells with pure colors, gradient colors, and patterns

      01:57

      How to fill cells with pure colors, gradient colors, and patterns

      When using WPS Spreadsheet to write a statistical data report, we may want to emphasize the cell data. To do this, we can fill the cell with background color and pattern.Take this table as an example. 1. If we want to fill the B3:G3 cell with color, select this area first.2. Click the Home tab above.3. Then click Settings.4. And finally click Cells. Or we can use the shortcut key Ctrl+1 to open the Formats Cells dialog box. · Pure colorClick Patterns, then we can choose a pure color to....

      Spreadsheet 474 views
      How to insert an attachment in WPS Spreadsheet

      How to insert an attachment in WPS Spreadsheet

      01:28

      How to insert an attachment in WPS Spreadsheet

      When we use WPS Spreadsheet, we need to insert an attachment in the table to add a supplementary explanation. Take this table as an example. We want to insert a document attachment in the corresponding table cells to add more information. Select cell F2, click the Insert tab and the File Object button to select the document we want to insert. When we are finished, a picture of the inserted document will appear. We can adjust the picture to the appropriate size and place it in the cell.....

      Spreadsheet 83 views
      Worksheet and workbook

      Worksheet and workbook

      01:48

      Worksheet and workbook

      Creating forms is an essential skill for our daily work. Mastering the form skills can make our work more effective. Now starting from the basic interface, we will explain what a form worksheet and workbook is.First, we click Spreadsheets on the New page, then click Blank to create a new blank file at the bottom. Now enter the main interface of the table. Above the table is the functional area, which is often used when we edit the table. We will also introduce the usage of these featur....

      Spreadsheet 205 views
      Create the double-layer doughnut chart

      Create the double-layer doughnut chart

      03:22

      Create the double-layer doughnut chart

      The double-layer doughnut chart can visually display the proportion of multiple data. As shown in the chart, this is the annual sales of a certain sales company. In this chart, we can see the proportion of sales per month and the sales percentage for each quarter. So how do we create the double-layer doughnut chart?First select the quarterly sales data in the cell range B2:B13, click the Insert tab and click the Insert Pie or Doughnut Chart drop-down button, then choose Doughnut in the....

      Spreadsheet 103 views
      Print out tables

      Print out tables

      02: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....

      Spreadsheet 176 views
      More features in Splitting Columns

      More features in Splitting Columns

      03:06

      More features in Splitting Columns

      When several pieces of information are filled in one cell, we often need to split it into multiple columns, and both WPS Spreadsheets and Microsoft Excel support splitting columns. Take this table as an example. In Microsoft Excel, we select the cell range of A2:A11, click the Data tab, click Text to Columns, and we can choose Delimited or Text Width to split columns manually. In addition to this original method, WPS Spreadsheets has a new feature, namely, Smart Split Columns. It has t....

      Spreadsheet 89 views

      How to insert a line for resume in WPS Office Word

      Welcome to WPS Official Academy to check the contents of how to insert a line for resume in WPS Office Word. You are sure to master the simple skills in inserting a line after reading this tutorial! · Steps to insert a line for resume in WPS Office Word1. Open your resume with your basic information.2. Head to the Insert tab, click the Shapes drop-down button and choose a line at Lines.3. Then draw a line in the suitable position by holding and dragging the mouse. You can further edit....

      Writer 226 views

      How to use PDF editor to split page in WPS Office

      Welcome to WPS Official Academy for free tutorials. You can Split the Pages by using the online PDF editor or by downloading WPS Office. You are sure to master the quick steps after reading this tutorial! · Quick steps to Split Page with PDF editor in WPS Office1. Open your PDF file in WPS Office.2. Head to the Edit tab, and click Split Page. Then we enter the Page Splitting mode.Note that the Split Page function is only available for WPS Premium users. You can click here to go premium....

      PDF 203 views
      Prev 12 Next
      WPS Academy