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

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

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,119,236
Messages
5,576,892
Members
412,752
Latest member
LUIS SAMANO
Top