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.
That was the case up to Excel 2003. In Excel 2007 the maximum number of rows per worksheet increased to 1,048,576 and the number of columns increased to 16,384 which is column XFD. That makes 17,179,869,184 cells. Excel 2010 and Excel 2013 have the same amount of rows and columns.