Steps to create a dynamic chart that changes with the scroll bar in Excel

1. Start Excel, execute the ctrl o key combination to open a prepared table data, and select the data area a1:b11.

2. Execute the Insert-Line Chart command to insert a line chart. Select cell e2 and enter 7. Execute the Formula-Define Name command and enter it in the pop-up dialog box. The name is date, the reference position is set to, click the OK button.

3. Right-click the chart and select the Select Data option from the drop-down menu. Then the Select Data Source dialog box will pop up. Click the Add button in the dialog box to pop up the Edit Data Series dialog box. box, set the series name to e and the series value to =sheet1! date, click OK.

4. Execute the Development Tools-Insert command, select the scroll bar from the drop-down menu, and drag to draw a scroll bar in sheet1.

5. Right-click the scroll bar, select the Format Control option from the drop-down menu, and then the Format Control dialog box will pop up.

6. In the Format Control dialog box, switch to the Control tab, set the minimum value to 1, the maximum value to 31, the page step size to 5, and the cell link to e2. , click the OK button.

7. Enter the formula =INDEX(B:B,E2 10) in cell f2, and then enter =INDEX(A:A,E2 10) in cell g2.

8. Right-click cell g2, select the Format Cell option from the drop-down menu, and set Custom to m/d in the pop-up dialog box. Click the OK button.

9. Right-click the chart and select the Select Data option from the drop-down menu. Select the Add button in the pop-up dialog box, select Series 3, select Edit, select the data area and click the OK button.

10. Select the grid to delete the grid and adjust the size and position of the chart. In this way, a dynamic line chart that changes with the scroll bar is completed. Just execute the file and save it.

The above is the detailed content of Steps to create a dynamic chart that changes with the scroll bar in Excel. For more information, please follow other related articles on the PHP Chinese website!