Excel graph Scroll bar for multiple series

Peteor

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

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

sijpie

Well-known Member
Joined
Nov 1, 2008
Messages
3,734
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,118,656
Messages
5,573,435
Members
412,529
Latest member
cTatch
Top