Stephen Bullen posts at DDOE there are three free chapters of the soon to be released Excel programming book “Professional Excel Development” available to read. The chapters are:
Chapter 1 - Introduction
Chapter 9 - Understanding and Using Windows API Calls
Chapter 15 - Advanced Charting Techniques
I’ve only browsed the Advanced Charting chapter and it looks like it contains some interesting info, including details on creating a Zoomable/Scrollable chart.