This requires you to parse the SERIES formula, which sounds like a major
pain, unless someone tells you that John Walkenbach has a class module
you can use that simplifies all that:
http://www.j-walk.com/ss/excel/tips/tip83.htm
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Wazooli wrote:
How do I get the series address in VBA? I want to dynamically change the
chart title based upon which column is used for the Y-values in an X-Y
scatter plot.
wazooli