We’ve known how to create a dynamic graph in Excel. In our today’s tutorial, we are going to know how to create a dynamic table in Excel.

Here is a fruit sale table from Monday to Friday.

We first select the table area and press Ctrl + T to create the table dialog box.

Go to the insert tab and insert a 2-D column.

Then, click on the Insert Slice.

Choose Fruit Name in the list.

When we click on the different types of fruits. The chart would be changed into the corresponding sale table.