How do I make an Excel dynamic icon? Excel Dynamic Chart Making tutorial

Are you still worried about the Excel dynamic chart making, today's small compilation teaches you the Excel dynamic Chart production, lets you bid farewell to Excel dynamic chart production the annoyance.

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

The production and beautification of graphs

Select the Dynamic Data area, then click Insert Chart, and finally make the chart landscaping.

Use CTRL to select the Drop-down menu control and the chart--Right click--to combine so that the control is merged into the diagram.

The final effect, as shown in the illustration, shows a different chart through the Drop-down menu control.

Above is the Excel dynamic chart production process Introduction, the operation is very simple, everybody according to the above steps carries on the operation, hoped can have the help to everybody!