MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Charts: The SeriesCollection's members values and name properties

Posted by Staffan on January 23, 2002 1:21 AM

Im pretty new to both Excel and VB(A). This is my problem.

If I have a diagram/chart and wants to change the source for the underlaying data I get a 1004 runtime-error. Which means something like "You are not allowed to chage [property] on the Series Class".

With code like:
ActiveChart.SeriesCollection(1).Values = strRange2
ActiveChart.SeriesCollection(1).Name = strRAnge3
ActiveChart.SeriesCollection(2).Values = strRange

Mostly it stops on all the code, sometimes though (dont know when ...) it can handle the (1), but I never get a serie after the first one to work.

Has anybody runned into my problem and have a solution?
All suggestions are welcome.

Random Info:
5 days ago I didnt know anything about either VB or advanced Excel ...
I tried to describe the "Range" in almost all possible ways (yes, that means I spend over 12 hours on this one)



Posted by LLoyd on March 21, 2002 3:03 AM

I've got the same problem

I've run into the same problem and the only way i've found of putting data onto a graph is Chart.SetSourceData which only allows one set of x values