You can run the following macros to set the limits on the x-axis. This kind of x-axis is based on a count, i.e. just because the first column is labeled some number, it is still 1 on the axis scale. Ex. If you want to plot columns 5 through 36, set 5 as the x-axis minimum, and 36 as the x-axis maximum.
the following excel restrictions per worksheet apply: 1  excel 2003: can handle 65k rows. 2  excel 2007 (and later): can handle 1M rows.
Limit/Restrict Scroll Area on an Excel Worksheet. See Also: Limit/Restrict Excel Scroll Area VBA. With Excel having 256 Columns and 65536 rows you may wish to limit, or restrict, the area that users can scroll to on your Worksheet. This can be done very easily by hiding all unused columns and rows.ere is how; 1  Locate the last used row on your worksheet. 2  Select the row number directly below your last used row so that the entire row is selected. 3  Hold down the Shift & Ctrl key and then push the down arrow. 4  This will select all rows down to row 65536. 5  With these rows selected go to Format Row Hide.