Hello! I am currently (attempting to use) using the =OFFSET(B2, $E$10, 0)) to create what I believe is a dynamic range (in hopes of being able to use a scroll bar).
The process I am using can be found at https://smallbusiness.chron.com/add-zoom-scroll-excel-chart-41823.html
The issue is my range is 686 rows (1 data series max is 255). This means my excel chart has several data series, and I am depicting 4 trends on the same chart. When populating the "cell link" field within the scroll bar control, I can only reference 1 of my dynamic ranges....
My question....
Is there a way to zoom and scroll on an XY scatter chart in Excel which has several data series either with controls or VBA?
The process I am using can be found at https://smallbusiness.chron.com/add-zoom-scroll-excel-chart-41823.html
The issue is my range is 686 rows (1 data series max is 255). This means my excel chart has several data series, and I am depicting 4 trends on the same chart. When populating the "cell link" field within the scroll bar control, I can only reference 1 of my dynamic ranges....
My question....
Is there a way to zoom and scroll on an XY scatter chart in Excel which has several data series either with controls or VBA?