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