WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


Quickly create dynamic charts with the slicer

Uploaded time: October 19, 2021 Difficulty Beginner

Quickly create dynamic charts with the slicer

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

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.

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.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.