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

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

sijpie

Well-known Member
Joined
Nov 1, 2008
Messages
3,727
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,521
Messages
5,548,544
Members
410,847
Latest member
shaun32
Top