Posted to microsoft.public.excel.programming
|
|
Error 1004 when setting a Series Collection.Values as Array via VB
Hi David
When applying array constants to the SeriesCollection there is an
upper limit to the number of characters that you can use (and it's
about 251 or so) - your array constant is exceeding this I'm afraid.
Another option might be to write these values to a range (eg in a
hidden sheet) and then refer the SeriesCollection to this range.
Hope this helps!
Richard
On 7 Jul, 10:08, David Messenger
wrote:
I am working in Excel 2000 with a Doughnut Chart.
I am trying to set-up the Chart with Series data "hard coded" into it,
rather than relying on a specified Range (because I want to part of the Graph
to be "fixed" and the other part variable via the Worksheet).
Extract from VB Code
With ActiveChart
.SeriesCollection(1).Values = Dial_Values
More CODE
End With
Where Dial_Values is the String Variable
"={1,0.15,1,0.15,1,0.15,1,0.15,1,0.15,1,0.15,1,0.1 5,1,0.15,1,0.15,1,0.15,1,*0.15,1,0.15,1,0.15,1,0.1 5,1,0.15,1,0.15,1,0.15,1,0.15,1,0.15,1,0.15,1,0.15 ,*1,0.15,1,0.15,1,0.15,1,0.15,1,0.15,1,0.15,1,0.15 ,1,0.15,1,0.15,1,0.15,1,0.1*5,1,0.15,1,0.15,1,0.15 ,1,13.75}"
This has 71 numbers in it.......
Code works for any combination of 71 numbers or below (ie 60, 50 numbers
etc) and with any combination of Values (ie 1,0.15 or 1, 0.2 etc).
If try ABOVE 71 numbers get
Runtime Error 1004
"Unable to set the Values property of the Series Class"
Tried both using the String Variable and with the value of the String
directly written as Code.
However if I manually go into the Graph and add more than 71 numbers as an
Array into the Source Data it works ?
Same issue occurs if taking same approach with Xvalues.
Am I doing something wrong or is 72 some undefined internal limit ?
Obscure question I know but ... Any suggestions ?
Thanks
|