Excel graph Scroll bar for multiple series

Peteor

Board Regular
Joined
Mar 16, 2018
Messages
132
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?
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

sijpie

Well-known Member
Joined
Nov 1, 2008
Messages
3,728
Don't understand why you are limited to 255 data sets. I can easily create a line graph with 2 years of daily data
 

Watch MrExcel Video

Forum statistics

Threads
1,114,570
Messages
5,548,831
Members
410,875
Latest member
longstrb
Top