I have some financial data in an excel table which has dates as rows and contract maturities (1 to 12) in columns. I want to create a dynamic chart in excel where i want to specify specific dates(1 or more) or a date range and specify contract maturities (one or more or a range). Ideally i want to specify these filters in specific cells on my worksheet and the chart should pick up those filters from there and output the chart.
Hope this is clear enough. Thanks a lot in advance for your help