| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ActiveChart.Location help | Excel Discussion (Misc queries) | |||
| Edit Chart Macro Help - Skip ActiveChart Selection if no data | Excel Programming | |||
| ActiveChart.ADD Fails | Excel Programming | |||
| How does the ActiveChart.Location() work | Excel Programming | |||
| Argument List Of ActiveChart.Location And ActiveChart.ChartType | Excel Programming | |||
Linear Mode
