I should have mentioned that there are a few #N/A's. But it pulls them
in and then it just stops somewhat randomly on row 6503. I guess I
have to do a work around in another column.

Thanks for your responses..
Jon Peltier wrote:
Assuming the charts properly use these names in the series formulas (because
you say they sometimes work)...

If you have any numerical cells above S4, it will throw off your count, and
your named range will extend lower than you intend.
If you have any blank or nonnumeric cells before the last numeric cell in
column S, it will also throw off your count, and the range will not extend
as low as you intend.

23 names is not near any limit. 23 series is far less than the capacity of a
chart. If you have more than 32,000 points in a name, you will only get the
first 32,000 of them in the chart (or you may get an error stating this
limit when you try to apply it).

Other than that, I can't think of a problem.

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


wrote in message
ups.com...
This is one of twenty three names...Thanks!

CRB_Index =OFFSET(Data!$S$4,0,0,COUNT(Data!$S:$S),1)




Jon Peltier wrote:
Post the names and refers-to formulas you're using.

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


wrote in message
oups.com...
I have successfully created a dozon or so dynamic charts though I ran
into a problem where one named series or the other will only pull in
only a certain portion of the range of cells. I have deleted named
series and then renamed it and that worked once. Now this doesn't work
for the series that has most recently been infected. Is there a
limitation on series names/dynamic charts that I may be missing?

Thank you in advance for any attention to this matter.

Ben