http://www.oaltd.co.uk/Excel/Default.htm

this is Stephen Bullen's page

Look for charting example and file called funchart7.zip

This demonstrates how to used defined names and scroll / zoom bar. Cool stuff.