You have to parse the series formula to discover the range containing the
data, then knowing it's the Kth point of the series, identify the Kth cell
of the range. I did this on a project a couple years back, so I could find
the routine, but it would take a while to find the backup CD. Use John
Walkenbach's chart series formula module to parse the formula:

http://www.j-walk.com/ss/excel/tips/tip83.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Andreas Wendzel" wrote in message
ups.com...
Hi Jon,

thanks for your answer. It helps me a lot.
How can I determine which cell the source of a point in x-y diagramm
is?
I tried to use srSeries.Points() but I can't find any order in this
collection.
Thanks,

Andreas