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.
By default each MS Excel sheet has 1048576Rows and 16384 Columns. if you click on the top left if the sheet on the rectangle above row #1 and left of column# A, you will see1048576R x 16384C. This is the default number of rows and columns. It should let you put in more records than 65,000 but trying impring them to same sheet in smaller groups.