Erroneous Error? re >32,000 data plots in 2D chart

[inews]

I am getting the error regarding >32,000 data points in a 2D charts in
Excel 2003. The same error as in the following post;

http://groups.google.com/group/microsoft.public.excel.charting/browse_frm/thread/79458c5c753083a2

However, the largest series I am plotting is only 16,401 data points
long.

Has anyone previously come across this error statement issued in
error?

===========
More background.

Have defined some chart series using dynamic named ranges.
E.G., name the following range "Series1", =OFFSET('C'!$M
$20,,,COUNTA('C'!$M$20:$M$30000),1)
Then in Chart/Source Data/Series/Values put "='WorkBook.xls'!Series1"

I considered this as the source of the problem, thinking that even
though the dynamically filled area is only 16,401 data points, the
offset area might still be upsetting it.

However, as you can see, the dynamic area is still <32,000 data
points.

Secondary question: my dynamically named ranges don't appear in the
"Name Box" on the toolbar. Is that normal behaviour?

 

[inews]

Ah, NOW I see. However, am still interested in the secondary
question;

"my dynamically named ranges don't appear in the
"Name Box" on the toolbar. Is that normal behaviour? "

However, have sorted the 32,000 data points question.

I have a number of 2D charts over an area of data which normally is
restricted by autofilter. The area is 63,000 data points, which is
normally not a problem, with autofilter restricting those to a few
thousand at a time.

It so happens that that area is empty at the moment.
Fix; Fill with dummy data. First cell with "1", fill remaining 62,999
cells with "2". Apply custom autofilter to only show "1". Charts now
show 1 data point of value "1". Will wait to see if problem goes
away. For some reason, the error used only to show up after a period
of time.

 

[Jon Peltier]

Ah, NOW I see. However, am still interested in the secondary
question;

"my dynamically named ranges don't appear in the
"Name Box" on the toolbar. Is that normal behaviour? "

Yes, that's typical behavior.

- Jon

 

[inews]

Yes, that's typical behavior.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -http://PeltierTech.com
_______

Thanks Jon.