875 results for create an excel chart that automatically updates with new data
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
875 results for create an excel chart that automatically updates with new data
Use pivot chart to create a dynamic chart
04:49Use 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....
How to insert a chart and edit the chart data in WPS Presentation
03:29How 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. ....
How to insert a chart and edit the chart data
02:12How 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....
Use VLOOKUP function to create dynamic charts
03:44Use 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....
How to create a Combination chart quickly
03:43How 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....
Master the Alt key to work efficiently
02:04Master 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....
How to create a bubble chart
03:20How 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....
More features in AutoFilter
02:39More 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....