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.
Before anyone jumps in, I am not talking about the maximum worksheet size of 1048576 rows by 16384 columns. I have client whom has a 1.5 Gb CSV file, 1.9, 2.6, 5, 17 and 89 Gb file (Huge). If I open the 1.5 Gb, the file opens (After waiting 5 minutes) and then a warning pops up that only the first 1048576 rows have loaded. That is fair enough. If I try and open any of the others, Excel comes up to a blank worksheet.