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.
Post subject: maximum number of rows in Excel. Hi Guys, I know that there is a limit of around 65,000 rows in Excel. Also we have some workaround to get more than 65k rows. Can any one tell me whats the maximum nulber of rows we can have in Excel. I need to export around 600,000 rows in Excel.