Thread: retreiving the range of a graph
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Arne Arne is offline
external usenet poster
  
Posts: 35
Default retreiving the range of a graph
Ah, thanks!

"Tushar Mehta" wrote:

In article ,
says...
I have a number of X,Y-charts on a worksheet, which represent data on another
sheet in the same workbook. How can I establish (using VBA, of course) which
range corresponds to each series of a chart? TIA,

Arne

Adapt John Walkenbach's code at
http://www.j-walk.com/ss/excel/tips/tip83.htm

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

Reply With QuoteReply With Quote