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

        875 results for create an excel chart that automatically updates with new data

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

        875 results for create an excel chart that automatically updates with new data

        Use pivot chart to create a dynamic chart

        Use pivot chart to create a dynamic chart

        04:49

        Use pivot chart to create a dynamic chart

        A pivot chart is a graphical representation of a pivot table, which can clearly and intuitively visualize the data. Suppose we now want to create a pivot chart of the total sales of each branch in the fourth quarter. How can we do that? Take this table as an example. Select any cell in the data area, click the Insert tab, then the PivotChart button. Now select New Worksheet in the popup dialog box, and click OK. After that, we can create an empty PivotTable and an empty PivotChart.In W....

        Spreadsheet 13.7K views
        How to insert a chart and edit the chart data in WPS Presentation

        How to insert a chart and edit the chart data in WPS Presentation

        03:29

        How to insert a chart and edit the chart data in WPS Presentation

        When we use PPT for data reporting, we often insert charts to help us further illustrate.Take this PPT file as an example. So, how can we insert a chart in the slide? Click the Insert tab above, and then click Chart.In the pop-up dialog, we can select many different types of charts.The double-layered doughnut chart provides an intuitive comparison of the changes in the sales data proportion over the past two years. This video takes Doughnut as an example. Click Pie and click Doughnut. ....

        Presentation 15.5K views
        How to insert a chart and edit the chart data

        How to insert a chart and edit the chart data

        02:12

        How to insert a chart and edit the chart data

        When we organize the data of the document, we usually insert a chart for a supplementary explanation.Take this document as an example. The table in the document represents the annual sales volume of different regions. Now, let's look at the data comparison more intuitively by inserting a bar chart. Go to the Insert tab and click the Chart button. In the pop-up dialog, we can choose a variety of chart types. Click Bar and Stacked Bar, then a default style stacked bar is inserted int....

        Writer 25.6K views
        Use VLOOKUP function to create dynamic charts

        Use VLOOKUP function to create dynamic charts

        03:44

        Use VLOOKUP function to create dynamic charts

        In the last video, we introduced the tips for making dynamic charts quickly. And this video will show you how to create dynamic charts with the help of the VLOOKUP function. Some knowledge points such as drop-down lists, VLOOKUP function, and absolute references are involved in making dynamic charts. If you are not familiar with these knowledge points, you're welcome to enter WPS Academy to search for learning. Take this table as an example. We're going to create a dynamic char....

        Spreadsheet 13.0K views
        How to create a Combination chart quickly

        How to create a Combination chart quickly

        03:43

        How to create a Combination chart quickly

        The Combination chart combines two or more types of charts in one coordinate system. We take this table as an example to explain how to make a Combination chart in WPS Spreadsheet. Here is the data of temperature and rainfall in a region. From this table, we can see three sets of data, namely, Rainfall, Mean Rainfall, and Temperature.We choose the cell range A1:D8, click the Insert tab, click Chart, and select Combo in the pop-up dialog.Gif At the top of the dialog, WPS Spreadsheet pro....

        Spreadsheet 8.2K views
        Master the Alt key to work efficiently

        Master the Alt key to work efficiently

        02:04

        Master the Alt key to work efficiently

        When working with tables, skillful use of shortcut keys can greatly improve our work efficiency.Today, we will learn some tips about the Alt shortcut key.· 1. Wrap text automaticallyTake the table as an example. The text of the title is too long. So, we need to wrap it. Select the cell and hold down Alt+Enter at the position where it needs to wrap.· 2. One-click AutoSumIf Weekly Total is required for each assembly line, select cell area J3:J13, and press Alt+= to sum with one click.· 3....

        Spreadsheet 7.4K views
        How to create a bubble chart

        How to create a bubble chart

        03:20

        How to create a bubble chart

        Similar to a scatter chart, a bubble chart is mainly composed of bubbles and variables to display information. Unlike scatter charts that can only display variables in the X and Y axis, bubble charts display the skill to the third variable with bubble areas.Bubble charts can be used widely in making maps- a perfect match for displaying data with regional characteristics.This is the survey data of mobile phone sales in a certain area. Let's take it as an example to make a simple bub....

        Spreadsheet 6.9K views
        More features in AutoFilter

        More features in AutoFilter

        02:39

        More features in AutoFilter

        When dealing with large amounts of table data, we often need to temporarily hide some of them with AutoFilter to focus on those we need. Here we will compare the AutoFilter function of WPS Spreadsheets and Microsoft Excel. In general, both of them support filtering data according to numbers, text, color and so on.WPS Spreadsheets has three special advantages. Let's go through them one by one.First, Click the Home tab, and click the AutoFilter drop-down button to turn on the AutoFil....

        Spreadsheet 8.4K views
        Prev 1 2 3 ... 109 110 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