thanks Raj, I've just noticed, it's still too complicated to me but with the time maybe.
Thanks Pawel ________________________________ From: Rajan_Verma <[email protected]> To: [email protected] Sent: Tuesday, June 5, 2012 1:49 PM Subject: RE: $$Excel-Macros$$ Graph with radio button Hi, There are three Simple VBA Procedure to accomplish this task. I have created 3 name ranges in your sheet Team1,Team2 and Team3 then on Every Option Button Click Event I am assigning the Current Region of Corresponding Range to the Chart Source. Sub OptionButton1_Click() Sheet1.ChartObjects("Chart 1").Chart.SetSourceData Sheet1.Range("team1").CurrentRegion End Sub Sub Sheet1_OptionButton2_Click() Sheet1.ChartObjects("Chart 1").Chart.SetSourceData Sheet1.Range("team2").CurrentRegion End Sub Sub OptionButton3_Click() Sheet1.ChartObjects("Chart 1").Chart.SetSourceData Sheet1.Range("team3").CurrentRegion End Sub Regards Rajan verma +91 7838100659 [IM-Gtalk] From:[email protected] [mailto:[email protected]] On Behalf Of pawel lupinski Sent: 05 June 2012 3:37 To: [email protected] Subject: Re: $$Excel-Macros$$ Graph with radio button Hi Rajan, is there any chance, that you can explain me how you've done it? Regards, Pawel ________________________________ From:Rajan_Verma <[email protected]> To: [email protected] Sent: Monday, June 4, 2012 2:11 PM Subject: RE: $$Excel-Macros$$ Graph with radio button HTH Regards Rajan verma +91 7838100659 [IM-Gtalk] From:[email protected] [mailto:[email protected]] On Behalf Of Anil Gawli Sent: 04 June 2012 2:58 To: [email protected] Subject: Re: $$Excel-Macros$$ Graph with radio button See the attached data Regards, Gawli Anil On Mon, Jun 4, 2012 at 2:38 PM, santosh subudhi <[email protected]> wrote: Hi Maries, Thankyou for your early response. I want to show only the list of people who are available. I mean when I will select "team 1" then the graph should show only the data for the three people and no zero's . Hope I am clear with query. Regards Santosh [email protected] From: [email protected] Date: Mon, 4 Jun 2012 02:01:14 -0700 Subject: Re: $$Excel-Macros$$ Graph with radio button To: [email protected] Hi, PFA... On Mon, Jun 4, 2012 at 1:39 AM, santosh subudhi <[email protected]> wrote: Hi Group, I want to create a graph which will show the work performance of different teams as and when they are selected. Attached is the sample sheet for your easy reference. -- Regards Santosh [email protected] -- FORUM RULES (986+ 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 [email protected] To unsubscribe, send a blank email to [email protected] -- MARIES Excel Inspiration -- FORUM RULES (986+ 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 [email protected] To unsubscribe, send a blank email to [email protected] -- Regards Santosh [email protected] -- FORUM RULES (986+ 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 [email protected] To unsubscribe, send a blank email to [email protected] -- Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- FORUM RULES (986+ 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 [email protected] To unsubscribe, send a blank email to [email protected] -- FORUM RULES (986+ 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 [email protected] To unsubscribe, send a blank email to [email protected] -- FORUM RULES (986+ 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 [email protected] To unsubscribe, send a blank email to [email protected] -- FORUM RULES (986+ 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 [email protected] To unsubscribe, send a blank email to [email protected] -- FORUM RULES (986+ 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 [email protected] To unsubscribe, send a blank email to [email protected]
