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.
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)