Anybody familiar with codes for chart in excel?

[TTThio]

Hi,

I'm kind of stuck right now. Trying to set the name of the series of a chart but keeps getting error 1004

"Unable to set/get Name property of the series class"

In chart(1), I had previously created 12 series (months)
I do debug.print worksheets(1).chartobjects(1).chart. _
seriescollection(i).count equals to 12. Correct!

But then, when I tried to set the name of each series, exp:
With worksheets(1).chartobjects(1).chart
.seriescollection(1).name = "X"
.seriescollection(2).name = "Y"
End with
Upon the 2nd series, I've already got the error message.

Can someone help me with this? I've no clue at all. Tried to surf help around, couldn't find answer to it.

Thanks ahead,
Tin Tin

 

[Beren1h]

You might want to try an record a macro doing this manually. After that you can look in the VB editor and see the code it created.

 

[accessuserit]

How activate a second series of data in a chart?
My query produce this data:
[qality1],[price1], and [qality2],[price2]
for example with tis value: [110],[95] and [107],[98]

If insert only the field [qality1],[price1] in a graph, the result of the graph is correct, are generated a point with the correct coordinate, quality in the x axis, and price in the y axis, the result is a point (correctly)

If i try to add other two values ([qality2],[price2]present in the same record, the graph is incorrected. Are used only 1 value for the x axis. In graph generator in access, do not have the possibility to use two series of value.
Do you know a solution?
Tanks for your time!

Paul, Italy