View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
PCLIVE
 
Posts: n/a
Default 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