Hi! I need to create about 50 charts on one worksheet. The data are in columns on another worksheet. On this worksheet in the "B" column are the dates that will be the X values for each chart. In the "D" column are the Y values for the first chart.
I understand that I need to set up a loop that will move one data column to the right each time through. My question is how to format the data range in the subroutine so that I can add to the range. For the date (X vales that don't change) my range statement goes like this; I found this by macro-recording while I built a chart:
ActiveChart.SeriesCollection(1).XValues = "='array wt 2011'!$B$6:$B$118"
And the Y-values (which need to increment by one each time) are stated like this:
ActiveChart.SeriesCollection(1).Values = "='array wt 2011'!$d$6:$d$118"
Maybe I can add 1 to "$d$6:$d$118" with OFFSET?
I have searched around and it seems that some have used R1C1 ranges to do this, but don't I need to change the whole worksheet or workbook over to this format to use it in the subroutine?
Others have used Cell to specify the range.
I haven't been able to get any of these to work. It would be great if someone has advice. Thanks!
I understand that I need to set up a loop that will move one data column to the right each time through. My question is how to format the data range in the subroutine so that I can add to the range. For the date (X vales that don't change) my range statement goes like this; I found this by macro-recording while I built a chart:
ActiveChart.SeriesCollection(1).XValues = "='array wt 2011'!$B$6:$B$118"
And the Y-values (which need to increment by one each time) are stated like this:
ActiveChart.SeriesCollection(1).Values = "='array wt 2011'!$d$6:$d$118"
Maybe I can add 1 to "$d$6:$d$118" with OFFSET?
I have searched around and it seems that some have used R1C1 ranges to do this, but don't I need to change the whole worksheet or workbook over to this format to use it in the subroutine?
Others have used Cell to specify the range.
I haven't been able to get any of these to work. It would be great if someone has advice. Thanks!
