See John Walkenbach's site:

http://j-walk.com/ss/excel/tips/tip83.htm
A Class Module to Manipulate a Chart SERIES
Excel's object model has a serious flaw: There is no direct way to to use
VBA to determine the ranges used in a chart. This tip contains a useful
class module that can simplify the task of manipulating chart's using VBA.

--
Regards,
Tom Ogilvy



Dave F wrote in message
...
Hi

Excel '2000 SR-1

I have a Line type chart embedded in a worksheet.
It has a single line of information (called a series I believe).

I know how to set the series data range (SetSourceData) , but I'm having a
lot of trouble getting the range.

Please point me in the correct direction.

Thanks in advance

Dave F.