To add to the list of scroll - zoom examples, this link shows an Excel chart
that lets user select data series with checkbox, zoom by selecting time span
to look at (year, month, etc) and scroll data.
The link has a video and the downloadable workbook.
Kelly
--
Stop Spam - Edit E-mail address by removing **s
***
http://processtrends.com/pg_chart_sc...r_checkbox.htm
"Del Cotter" wrote in message
...
On Thu, 23 Nov 2006, in microsoft.public.excel.charting,
Andy Pope said:
Here are some resources on dynamic named ranges as used in charts.
You can use cells linked to controls to vary the start points and or
lengths in the offset formula.
http://peltiertech.com/Excel/Charts/Dynamics.html
http://tushar-mehta.com/excel/newsgr...rts/index.html
http://www.andypope.info/charts/Scrolling.htm
Also, Stephen Bullen has a ready-made chart with both scroll and zoom on
his page
http://www.oaltd.co.uk/Excel/Default.htm
It's the file "FunChrt7.zip"
http://www.oaltd.co.uk/DLCount/DLCou...e=FunChrt7.zip
Jon Peltier's Dynamics page links to Stephen Bullen, but only
FunChrt1.zip, the "automatically extend data series" chart.
--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.