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.
The maximum number of columns in Excel is 256. This is checked by the Excel export option, and an error is displayed in Excel if the limit is exceeded. The maximum column width in Excel is 255 characters or 1,726.5 points. This is not checked by the Excel export option.