Max length of chart data series array

[madge]

I dynamically produce my chart and the SeriesCollection.Values
property is populated as an array (as opposed to a range). It has to
be an array because the values are calculated.

It all worked well for a number of weeks but now I get an error when
producing the charts. The error is 1004 - Unable to set the Values
property of the Series class.

The problem seems to be that my Array (43 values in it when the error
happened.) appears to be longer than what the Values property can
handle. It plots fine if I have 42 values in the array.

Has anyone come across this before? The values are currently
formatted to 1 decimal place before they are entered into the array.
If I format them to zero decimal places, then it lets me plot my 43
values but I don't like this because the rounding differences adversly
affect the calculated values that I am plotting.

How can I adjust the Values property so it lets me plot more than 42
weeks of calculated values?

Thanks
madge

 

[Jon Peltier]

Madge -

Tushar's approach is my preferred way to deal with this. Data in a
worksheet is more robust and easier to use than data in the chart series
formula or a named range. But I have presented some information about
this on my web site. You might be able to extend your data by rounding
to eliminate irrelevant decimal digits, as I discuss near the end of
this page:

http://www.geocities.com/jonpeltier/Excel/ChartsHowTo/DelinkChartData.html

- Jon