View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JP JP is offline
external usenet poster
 
Posts: 103
Default 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