How does Excel make a dynamic chart?

How does Excel make a dynamic chart?

1. Create a form

Click the Development tool--click Insert--form control.

Right-click--Set control formatting

Data source region: As shown in the chart, the company's cell range

Cell Link: A9 (not fixed)

Drop-down Display number of items: 4 (that is, the number of data source range).

The effect is as shown in the Drop-down menu control.

2. Use the lookup function to establish a dynamic data source with the form

As shown, enter the formula, and then copy the formula to the right.

For the index function, you can refer to the experience of the small series

How to use the Index function in Excel

As shown in the picture, click the Drop-down Menu control, select a different company, the data referenced by the formula is changing, the effect as shown in the picture.

In this way, you use the lookup function to create a dynamic data source with the form