ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ActiveChart, Data!R code (https://www.excelbanter.com/excel-programming/414804-activechart-data-r-code.html)

JP

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


All times are GMT +1. The time now is 12:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com