Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Erroneous Error? re 32,000 data plots in 2D chart
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/micro...458c5c753083a2 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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Erroneous Error? re 32,000 data plots in 2D chart
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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Erroneous Error? re 32,000 data plots in 2D chart
wrote in message ... 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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Erroneous Error? re 32,000 data plots in 2D chart
Yes, that's typical behavior.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ Thanks Jon. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent Excel chart flicker,when plots are linked to DDE data | Charts and Charting in Excel | |||
can i do multiple plots on 3d chart? | Charts and Charting in Excel | |||
VLOOKUP Returns Erroneous Value When Control Data is Variable | Excel Worksheet Functions | |||
Box-and-whisker chart (box plots) | Charts and Charting in Excel | |||
two scatter plots with two trendlines on one chart | Charts and Charting in Excel |