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.
First, Excel has a row limit of 65,536. If the combined amount of data exceeds this amount, you will not be able to store it in one Excel file. Second, CSV and XLS are fundamentally different. CSV is a text-only file that you can open with any text-editor. XLS files are binary representations of all kinds of data, text being only a small part, that are generally only supported by Excel and other spreadsheet applications.