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.
Even though each worksheet in Excel can have more than 1,000,000 rows and more than 16,000 columns it's not often that we need that much room. Mostly we use considerably fewer than the maximum number of rows and columns and sometimes it might be an advantage to limit access to unused areas of the worksheet.