Excellent, Thanks you so much both of you,
I am little confused about Mr.Sam's first solution due to its named ranges, its a new knowledge to me, I will try to understand. Thanks again both of you. On Sun, Nov 13, 2011 at 6:13 PM, Sam Mathai Chacko <samde...@gmail.com>wrote: > I'd recommend keeping the method safe by relying only on the source data. > From that echelon, I'd suggest using COUNTA to pass the column index in the > VLOOKUP argument, instead of referring to (an)other cell(s). > > =VLOOKUP($I$3,$I$9:$M$13,COUNTA($I$8:I$8),0) for example can be dragged > across from column I all the way to M, without relying on any other > range/cell. > > Also, since both solutions suggested rely on an exact match of the client > name, you could refer that cell directly in the chart source range, without > using a VLOOKUP. > > See attached. > > Regards, > > Sam Mathai Chacko > > > On Sun, Nov 13, 2011 at 8:05 PM, dguillett1 <dguille...@gmail.com> wrote: > >> See attached >> >> Don Guillett >> SalesAid Software >> dguille...@gmail.com >> >> *From:* kurikkal padinjarappalla <padinjarappa...@gmail.com> >> *Sent:* Sunday, November 13, 2011 4:07 AM >> *To:* excel-macros@googlegroups.com >> *Subject:* $$Excel-Macros$$ To Set Dropdownlist in Chart >> >> Dear All, >> >> Could somebody help me by setting a drop down list for creating chart, as >> if I select a particular client name in drop down list it should appear the >> chart of that particular client. >> >> please find the attached sample sheet. >> >> Thanks for your valuable solutions. >> >> Regards, >> Kurikkal. >> -- >> FORUM RULES (934+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------------------------------------------------------------------------------ >> To post to this group, send email to excel-macros@googlegroups.com >> >> -- >> FORUM RULES (934+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------------------------------------------------------------------------------ >> To post to this group, send email to excel-macros@googlegroups.com >> > > > > -- > Sam Mathai Chacko > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
