If you want to retrieve the information when you click on the point, you
could probably adapt something from he

http://peltiertech.com/Excel/Charts/...html#PointInfo

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

jmikerea wrote:

How do I return the series formula (say in a msgbox) as it appears in
the formula bar when I click on a series point in an xy chart where
each point is a separate series? I can do something close if I
provide a seriescollection number when combined with j-walk's
excellent series class routine but I want it to pick up the number
automatically.