You can define a dynamic chart based on named ranges. To name a range, go to the Insert menu > Names > Define. In the Name box, enter the name, and in the Refers To box, enter the formula that defines the range.
So your data starts in A1, is 180 columns wide and 17565 rows high, in Sheet 1 of Book1.xls. In Sheet 2 cell B2, enter a value between 1 and 180.