Select the series, and look in the formula bar.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Taylor" wrote in message
...
'Not sure how you got your formula data, this may be the hard way, but
I write in my VBA debugging window (with the chart selected):
debug.Print activechart.SeriesCollection(1).FormulaLocal
(is this how you got yours?)