returning a chart series formula

[Guest]

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.

 

[Jon Peltier]

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/chartvba.html#PointInfo

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

 

[Guest]

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/chartvba.html#PointInf

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

jmikerea wrote