Charts and VBA

I am trying to repurpose an existing series that I have in multiple charts-there are well over a hundred charts in one worksheet, so trying to do via vba. Warning: Very new to VBA!

In each chart, Series 1 references data in columns A-C, but different rows. So for example Series 1 in chart 1 is A1:C1, and Series 1 in Chart 2 is A2:C2. Is there a way using vba to change Series 1 in all of my charts to refer to columns D:F, without changing the reference to the rows? (so end result would be Series 1 in chart 1 D1:F1, and Chart 2 D2:F2)?
Thank you in advance.

hi
try this

Please Login or Register  to view this content.

Hi Nicky, thank you so much for your response! Its not 100% working for me but I need to play around a bit as I may not have asked my question in its entirety. If I can just ask, the (2) above in the code, what does that refer to/mean?

Nicky thank you! I so appreciate you taking your time to explain that to me, really does help me out a lot. If I can ask one more question (sorry!). I am assuming that the (1) after SeriesCollection refers to Series 1. So if I have 2 series in my chart, only series 1 will be impacted by this macro. Am I correct?

yes that's right. In your original post you indicated that series 1 was the series you want to change. If you want to change other series you could repeat specifying other particular series or, if you want to change all series, you could use a for each ... next command like this:

Please Login or Register  to view this content.

Thank you from the bottom of my heart Nicky! You have been so helpful!