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.
Insert rows on a worksheet. Do one of the following: To insert a single row, select either the whole row or a cell in the row above which you want to insert the new row. For example, to insert a new row above row 5, click a cell in row 5. To insert multiple rows, select the rows above which you want to insert rows.imilarly, you can insert rows above a selected row and columns to the left of a selected column. You can also delete cells, rows, and columns. Note Microsoft Office Excel 2007 has more rows and columns than ever before, with the following new limits: 16,384 (A to XFD) columns wide by 1,048,576 rows tall.