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.

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

Cheers
Andy

Prince Ali wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

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.

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.

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_sc...r_checkbox.htm
http://www.oaltd.co.uk/DLCount/DLCou...e=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




"Kelly O'Day" wrote:

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.