How does Excel make a dynamic chart? Are you still distressed with scrolling controls for Excel dynamic charts, and today's small compilation of Excel dynamic chart making with scroll bar controls allows you to bid farewell to Excel dynamic chart making with scroll bar controls.
First, create a form control
1, click the Development tool--insert--scroll bar form control.
2, right click--Set the control format.
Minimum value--1 Month
Maximum Value--12 Month
Cell Link--d2
Second, define the name to establish a dynamic data source
1, click the formula-name manager.
2, month reference =offset (sheet1! $A $2,1,,sheet1! $D $2,1)
Indicates that the A2 cell is the frame of reference--row offset 1 row, column not offset--returns D2 row, 1 column.
Quoted by Shanghai =offset (sheet1! $B $2,1,,sheet1! $D $2,1)
Quotations from Nanjing =offset (sheet1! $C $2,1,,sheet1! $D $2,1)