Chart Series Question

  • Thread starter Thread starter Jamie
  • Start date Start date
J

Jamie

I'm trying to write a macro that will check all of the series in a
given chart and make sure that they are pulling from the same sheet
name. Is there a way to step through each series value, extract the
sheet name it's pulling from (I could feed this into an array), and
then compare those values (I could use the filter function on the new
array). I just can't seem to find a way to extract each series value
in order to pull them into an array. Any help would be appreciated.
I guess I'm just not real familiar with series/seriescollection
syntax.

Thanks,
Jamie
 
Back
Top