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

Link to free chapters

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.