Reference a Range Variable with a for next loop using the current iteration number

Hi, this is probably glaringly obvious/simple but I have not been able to figure it out.

I've got some range and other variables for charts set as follows:

Please Login or Register  to view this content.

Later on then, I go to deploy these to build some charts within a For ... Next loop ( i = 1 to 3 )

Please Login or Register  to view this content.

The above shows just one failed attempt to call the first range variable, ChartSeriesName1, as the first step in building first chart.

This one obviously converts the the set range variables to string variables and the plotting fails.

I have tried several other iterations which I won't get into.

So I believe I am missing a simple principle/technique to build each chart in turn by ref to the i in the loop, but I just can't find it.

If anybody could help, would be very grateful.

I think, if you want to loop through the charts, you would be better off setting the parameters up in arrays rather than individual variables.

For example (untested):

Please Login or Register  to view this content.

With this arrangement, you could create a loop to set up the array elements, if you wish (for example, if there are more than 3 )

Once you have your arrays of parameters, you can loop through them.

I've shown setting up a one dimensional array of names, but you could set up a two dimensional array and add the rest of the chart parameters in a single array.



Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

You're welcome.



Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Thank you