[stu_design]

Hey

I have a prob

Im creating a graph thru vba and its not allowing me to change series value and name
its a 1004 error code
"Unable to change Series values": or something

How do i change or do it?

Plz any1 Help????

[Advertisements]

found this out on my own

With ActiveChart.SeriesCollection.NewSeries
.Name = x
.Values = Worksheets(x).Range("a2")
End with

PS this is using vba

[stu_design]

found this out on my own

With ActiveChart.SeriesCollection.NewSeries
.Name = x
.Values = Worksheets(x).Range("a2")
End with

PS this is using vba

[admin]

Closed at users request.