1810 results for charts and graphs
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
1810 results for charts and graphs
Line Charts and Area Charts
09:37Line Charts and Area Charts
In this lesson, we learned about the basic use of line and area charts.1.A line chart and an area chart are essentially identical. Both may effectively display data trends over a specific time period, but an area chart is better for displaying the stacked effect.2.The combo of a line chart and an area chart can diversify the data. The right color scheme can make the chart more advanced.3.In the same chart, a combo of line and column charts can display two sets of data with different di....
Pie Charts and Sparklines
10:02Pie Charts and Sparklines
You have learned two types of charts in today's lesson: pie charts and sparkline charts.1.Pie charts are suitable for showing data proportions, and data labels play an important part. The right-hand menu allows us to format data labels. 2.The combo of pie charts and doughnut charts can display complex data. A chart with too many colors should be avoided. We can choose the tone on tone color and adjust the saturation to improve the color matching. 3.Sparkline is a handy chart type. ....
Create simple and intuitive mini charts
03:10Create simple and intuitive mini charts
The mini chart can help us to compare and analyze data of a row or column. It is very useful when presenting data. So in this video, we are going to show you how to create simple and intuitive mini charts.In Sheet1, we can see Monthly sales of clothing. But we can't visually tell the difference between sales each month. Therefore, we should use the mini chart.1. Click the Insert tab.2. Click the Line buttons.3. Now a Create Sparklines dialog box will pop up.4. Select cells B3:J3 as....
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....
Different ways to utilize column charts
11:05Different ways to utilize column charts
Clustered columns are one of the most frequently used charts. Data discrepancies are reflected in the height of columns.1.We can highlight data by setting data labels, trendlines, the starting point of the Y-axis, and other methods. 2.We can set column size and gaps at "Series Overlap" and "Gap Width." 3.Stacked columns and 100% stacked columns can better display data percentage. They can clearly show the containment relationship for categories.
Quickly create dynamic charts with the slicer
01:12Quickly create dynamic charts with the slicer
We often use dynamic charts in our practical work. Use the mouse to select different preset items in the slicer. Then the chart will change with the selected item. This video will show you how to quickly create simple dynamic charts. Take this table as an example. We select any cell in the table, click Table under the Insert tab to create a super table, or we can use the shortcut Ctrl+L to quickly open Create Table, and click OK. Get into the Table Tools tab, and click Insert Slicer. I....
Use charts to present data
09:15Use charts to present data
1.In this lesson shared several chart types, such as column, line, pie, bar, area, scatter, radar, and bubble chart. Each chart has its own features and imperfections. We should pick the chart that best fits the topic. 2.Many different elements make up a chart, such as a chart title, data labels, trendlines, and so on. We should pick elements appropriately, concisely, and clearly. 3.We also learn the basics of ribbon buttons. We know how to change the chart type, how to switch rows and....
How to make elegant charts in WPS Writer
02:11How to make elegant charts in WPS Writer
Plain charts in a word file may fail to attract viewers. Subscribe to WPS Template membership, and you will be free to download beautiful charts from the vast library of charts to enhance the design and appeal of your charts. Click the Insert tab, click the Chart library button, and you are provided with diverse chart types like Column, Line, Pie, etc. You can choose a preferred type, and on the detail page, choose the desired chart to insert into the document quickly. If we need to ....