Help for Scroll and Zoom Charts

[Prince Ali]

Hi MVP !!!
I am tryoing to make a chart in which the set of dates can be scrolled, as
well as the number of dates present in the chart can also be varied.

As I am not very strong in Excel, Kindly tell me the steps involved in it.

Thanks in advance for your valuable support.

 

[Andy Pope]

Hi,

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/newsgroups/dynamic_charts/index.html
http://www.andypope.info/charts/Scrolling.htm

Cheers
Andy

 

[Del Cotter]

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/newsgroups/dynamic_charts/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/DLCount.asp?file=FunChrt7.zip

Jon Peltier's Dynamics page links to Stephen Bullen, but only
FunChrt1.zip, the "automatically extend data series" chart.

 

[Kelly O'Day]

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

 

[Prince Ali]

Hi Kelly O'Day
The support provided by you contains the same type of charts which I am
looking for, perticularly:
http://processtrends.com/pg_chart_scroll_bar_checkbox.htm
http://www.oaltd.co.uk/DLCount/DLCount.asp?file=FunChrt7.zip
the above examples are the type which I am looking for, but the above links
does not show the procedures to build the same type of charts by end users
like me.
I'll be greatful if you tell me the step by step procedure to dovelop the
same type of chart in Microsoft Excel 2000