Reference Data Range based on cell contents
 

I have a chart in which the Data range is set as follows:

='Sheet2'!$A$25:$M$37

Is it possible to do the following?
Where it states "$M$37", I'd like "37" to be based on a number that shows in
AB1.

Is that possible?

Thanks,
Paul