Quickly create dynamic charts

Uploaded time: October 19, 2021 Difficulty: Primary

Quickly create dynamic charts

Quickly create dynamic charts

Tips: After starting to play, you can adjust the video clarity, click

Quality

Auto 720p

Graphic skills

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. In the popup Insert Slicers dialog, we can check Name. Then, a slicer called Name will pop up.

_1.gif


Then, we select all table contents and click Chart under the Insert tab. Here we can quickly create a chart by pressing the shortcut Alt+F1. When we click the name on the slicer, we'll find that something magical has happened! The table and the chart we created will change at the same time, forming a linkage effect.

_2.gif


These are the tips for creating the simple dynamic charts. Did you get it?

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.