I use WorkbookDesigner to inject data into a template worksheet with a pre-built chart to cover a range of data area..  For discussion, let say the chart display investment performance with y-axis showing investment returns and a-axis shows the investment year.User wants to dynamically choose a range of years of investment returns to ...