send a variable to a series in a chart..

[neunelfer]

Hi there,

I'm not very experienced in programming VBA, but I have to..
My problem is, that I want to send a variable to a series in a chart..
and I tried it like this :

Worksheets("L CDMBAN1&quot.ChartObjects(1).Activate
ActiveChart.PlotArea.Select
'MsgBox ("=L CDMBAN1!R3C" & iColData & ":R" & intSweep & "C" & iColData)
ActiveChart.SeriesCollection(iColDataInt).XValues = "=L CDMBAN1!R3C" & iColData & ":R" & intSweep & "C" & iColData


I always get a $#@% error, and tried a ton of changes, but nothing helps.

Please excuse my bad english, I'm german

 

[SkipVought]

Hi,

Not sure exactly what you are doing, but here's some mods to your code that works

    iColDataInt = 1
    iColData = 3
    ActiveSheet.ChartObjects(1).Chart.SeriesCollection(iColDataInt).XValues = "=" & ActiveSheet.Name & "!R3C" & iColData & ":R6" & "C" & iColData

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[neunelfer]

shoot ..

I still get an runtime error 1004: unable to set XValues property of the series class.

Somebody knows what that means?

 

[SkipVought]

Don't use ActiveChart.

ActiveSheet.ChartObjects(1).Chart.SeriesCollection(iColDataInt).XValues =...

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com