ExcelScrollandZoom

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