I can create a dynamic range chart and a scrolling chart using a scroll bar.
However, I'm stuck on the the definition of the maximum range in the scroll
bar control box, which accepts numbers only, not COUNTA...

In learing how to do those, I relied on a few great pages by our resident
MVPs:

http://www.andypope.info/charts.htm
http://pubs.logicalexpressions.com/P...cle.asp?ID=518
http://www.ozgrid.com/Services/ExcelChartTools.htm
http://www.cpearson.com/excel/lookups.htm

but I was not able to blend the two tricks together..

Any tips and leads would be appreciated.

z.entropic