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