ActiveChart, Data!R code
I am troubleshooting some prior code which is giving me a 'invalid parameter'
error 1004. c and d are global integers. This was created in xl2003 and
appears not to work in xl2007. Are there suggestions on how to rewrite this?
ActiveChart.SeriesCollection(a).Name = "=Data!R" & c & "C" & d
ActiveChart.SeriesCollection(a).XValues = "=Data!R" & c & "C" & d + 1
ActiveChart.SeriesCollection(a).Values = "=Data!R" & c & "C" & d + 2
ActiveChart.SeriesCollection(a).BubbleSizes = "=Data!R" & c & "C" & d + 3
|