Excel Scroll and Zoom
I got frustrated with the useless and inaccurate blogs trying to explain how to add zoom and scroll on a chart in Excel.

Zoom and Scroll are very useful when you have a big data set.

In this example I have 1000+ rows of data. The left column is the X data (time) and I have 3 sets of Y data.

I've put some heading in the columns and also Scroll and Zoom values in a couple of boxes.

In Excel you can specify a set of rows of data as a variable (a Name). When you create a Name you can use the OFFSET command to define what block of rows is included in that Name. The offset command is used:

OFFSET(
reference, = some fixed cell (A1 in my case)
row offset, = an integer saying 'start at this many rows down from the the fixed cell' This is the value I put in G1 (the G1 value eventually becomes a variable controlled by the first horizontal scroll bar)
column offset, = how many columns to the right that the data will start. So for Xdata the value is 0 (zero) because the fixed cell (A1) is in column A and the Xdata data is in column A also. For Ydata1 (in column B) the column offset is 1, for the next set of data Ydata2 the column offset will be 2)
height, = the number of rows that will be in this Named data set. This will define the number of rows that will ultimately be shown in the chart I.E. the Zoom. This is an
integer and in my case that integer is in a cell G2 that varies according to the slider on a scroll bar the vertical scroll bar in my case.
width = the number of column in the Named data set. This is 1 in all my cases since I just want Xdata to be one column and Ydata1 etc to be one column also.

I figured, if you're watching this video then you'll know how to create charts :)

Hopefully this will help you get your Excel charts working with Scroll and Zoom