Many people don't know how to make dynamic charts. In fact, dynamic charts can be easily constructed by setting the application of Excel form controls. A computer store wants to count the monthly sales of five products (display, chassis, keyboard, mouse, and complete machine) and make a chart display. According to the usual thinking, we have to design a chart display for each of the five products, which is a bit complicated. In fact, a more professional approach is to use only one chart, the user selects the month to be displayed by the user through the drop-down list, and the chart automatically changes accordingly. The process of extracting data is mainly to extract the sales data of one month of the five products into another worksheet of the worksheet (of course, another area of the current worksheet) to create a chart. Since the chart is created based on the extracted data, rather than based on the original data, we will be able to easily switch the sales data for the month of the five products, that is, the data used to draw the chart. Enter =sheet1!A3 in the A3 unit of the sheet2 worksheet, then drag the fill handle of the A1 cell to copy it to A4:A7. We will use the value of the A1 unit of the sheet2 worksheet to control which month's sales data is to be extracted (that is, which batch of data the control chart describes). Now enter 1 in the A1 unit. Enter the formula =OFFSET(sheet1!A2,0, $A$1) in the B2 unit, then drag the fill handle of the B2 cell and copy it to B4:B7. The function of the OFFSET function is to extract data, which is referenced to the specified unit, offsets the specified number of rows and columns, and returns a new unit reference. In this case, the meaning of the OFFSET(sheet1!A2,0, $A$1) function is: find the same row and offset a column from A2(B2) and return the value of the cell (Figure 1). The process of making a chart is mainly to create a standard clustered column chart based on the data of A2:B7 in the sheet2 worksheet in the sheet1 worksheet. First select any blank cell in sheet1, select the “insert →chart” menu, select the chart type as “cluster column chart", click “next”, then click in the data area Red arrow, select the A2:B7 area in the sheet2 worksheet, then click the red arrow to restore the window, then you can preview a clustered column chart, and finally click the “Complete" button, then it will be in sheet1 Insert a chart in it. Check to see if A2:B7 and the chart actually show the sales data for the five items in January; if not, check if you follow the previous steps. Change the contents of the A1 unit to 2, check that A2: B7 and the chart show the sales data of the five items in February. Add a drop-down list combo box to the chart. In the sheet1 worksheet, select the menu “View → Toolbar → Form” (note that you can't select “Control Toolbox”), click on the “Club Box” on the toolbar. ” button, click on the blank position above the chart, add a drop-down combo box on the chart, we can drag the combo box to change its position, and drag its control point to change its size (Figure 2). Right-click on the combo box and select “Set Control Format”, then select the “Control” tab and set the "cell link" to Sheet2!$A$1 cell. Since the data area of the combo box control can only select the column area, we can enter 1 to 6 months in a blank column in sheet2 (such as D2 to D7 cells), and then set the data area of the combo box to Sheet2!$D. $2: $D$7, which is the D2:D7 area in the sheet2 worksheet. Click on the area outside the button on the chart, and then you can click on the drop-down list to display the corresponding chart based on the currently selected month (Figure 3). This article comes from [System Home] www.xp85.com