Plenty of information on Jon's site about intreactive charts
http://peltiertech.com/Excel/Charts/Dynamics.html