Creating dynamic data filters for charts

%3CLINGO-SUB%20id%3D%22lingo-sub-1537735%22%20slang%3D%22en-US%22%3ECreating%20dynamic%20data%20filters%20for%20charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1537735%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Friends%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%26nbsp%3B%20have%20some%20financial%20data%20in%20an%20excel%20table%20which%20has%20dates%20as%20rows%20and%20contract%20maturities%20(1%20to%2012)%20in%20columns.%20I%20want%20to%20create%20a%20dynamic%20chart%20in%20excel%20where%20i%20want%20to%20specify%20specific%20dates(1%20or%20more)%20or%20a%20date%20range%20and%20specify%20contract%20maturities%20(one%20or%20more%20or%20a%20range).%20Ideally%20i%20want%20to%20specify%20these%20filters%20in%20specific%20cells%20on%20my%20worksheet%20and%20the%20chart%20should%20pick%20up%20those%20filters%20from%20there%20and%20output%20the%20chart.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20is%20clear%20enough.%20Thanks%20a%20lot%20in%20advance%20for%20your%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1537735%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1538098%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20dynamic%20data%20filters%20for%20charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1538098%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F735911%22%20target%3D%22_blank%22%3E%40PrateekT%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDynamics%20X-axis%20range%20is%20more%20or%20less%20standard%2C%20more%20complex%20with%20dynamic%20series.%20Please%20check%20Jon%20Petlier%20comments%20in%20this%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fstackoverflow.com%2Fquestions%2F8274923%2Fdynamic-serie-selection-on-an-excel-chart%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fstackoverflow.com%2Fquestions%2F8274923%2Fdynamic-serie-selection-on-an-excel-chart%3C%2FA%3E%26nbsp%3Bdiscussion%2C%20he%20is%20%231%20in%20all%20questions%20related%20to%20charts.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

Hi Friends,

 

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

1 Reply

@PrateekT 

Dynamics X-axis range is more or less standard, more complex with dynamic series. Please check Jon Petlier comments in this https://stackoverflow.com/questions/8274923/dynamic-serie-selection-on-an-excel-chart discussion, he is #1 in all questions related to charts.