Make an Excel Dynamic Chart

[Janespola]

I have an excel sheet which has monthly data for 3 years and have plotted them on a graph.i would like to select a From Date and a To Date were in i select the data range/period and the Graph changes accordingly incorporating the duration which has been entered in the From and To Date.

 

[GraH - Guido]

On which version of Excel are you working?
Modern Excel comes with dynamic arrays, and you can reference them in chart series.
There is a chapter on Chandoo's blog post. Look for the filter function.

Excel Dynamic Array Functions - What are they, how to use them, Examples and FAQs » Chandoo.org - Learn Excel, Power BI & Charting Online

Newly released Dynamic Array Functions change everything about Excel. With DA functions, your formulas can return a range of values and spill over. Learn all about FILTER, UNIQUE, SORT, SORTBY, SEQUENCE and RANDARRAY functions in this comprehensive guide. Example workbook provided.

chandoo.org

However, he was incomplete on the charting part. Consider reading these:

Dynamic Charts Using Dynamic Arrays

With Dynamic Arrays, it is easy to define variable sized calculations. It is also easier to define Names for use in dynamic charts.

peltiertech.com

Dynamic Array Formula Spill Ranges With Charts

Excel MVP Chris Newman shows how to link Dynamic Array formula Spill Ranges into your Excel Charts to create graphs that reflect live changes to your data

www.thespreadsheetguru.com

How to use dynamic arrays with other features (7 scenarios)

How well do dynamic arrays work with Excel features, such as charts, data validation, conditional formatting, etc? Find out in this post.

exceloffthegrid.com