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.

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.

Thanks Jon it works a trea

Mik

----- Jon Peltier wrote: ----

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

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

- Jo
------
Jon Peltier, Microsoft Excel MV
Peltier Technical Service
Tutorials and Custom Solution
http://PeltierTech.com
______

jmikerea wrote

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