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 or delete cells, rows, and columns. You can insert blank cells above or to the left of the active cell on a worksheet. When you insert blank cells, Excel shifts other cells in the same column down or cells in the same row to the right to accommodate the new cells.Similarly, 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.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.