Here is my problem:
I am using ActiveChart.SeriesCollection(1).Formula to return string that
contains the location of the data for that series [ie.. =SERIES("NY
Jet",Table!$A$2750:$A$6500,Table!$C$2750:$C$5856,1 )]

Then I am using a string parsing function I made to chop out the name of the
worksheet to which that SeriesCollection came from. This seems like more work
than it should be just to return the worksheet(name) that a particular
SeriesCollection in a chart belongs too.

There has to be an easier way ??
Any thoughts ??

Dan Thompson