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