Re: $$Excel-Macros$$ Chart Template Dynamic for Different Users
Don, I spent hours going through that spreadsheet and learned a lot. Thank you for your help and teaching. John On Thu, Feb 23, 2012 at 12:16 PM, dguillett1 dguille...@gmail.com wrote: That’s because the defined name was not referenced in the chart sources. series=smith.xls!definedname Don Guillett SalesAid Software dguille...@gmail.com *From:* John A. Smith johnasmit...@gmail.com *Sent:* Thursday, February 23, 2012 9:25 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Chart Template Dynamic for Different Users Xlstime, I saw that but when I added another product it didn't show up on the chart. John On Thu, Feb 23, 2012 at 10:20 AM, xlstime xlst...@gmail.com wrote: in Name Manager, press alt+i+n+d On Thu, Feb 23, 2012 at 8:47 PM, John A. Smith johnasmit...@gmail.comwrote: Xlstime, Where do I put that formula? John On Thu, Feb 23, 2012 at 10:10 AM, xlstime xlst...@gmail.com wrote: Dear John, Please find the attachment use formula =OFFSET($A$2,0,0,COUNTA($A$2:$A$10),COUNTA($A$2:$F$2)) On Thu, Feb 23, 2012 at 8:13 PM, John A. Smith johnasmit...@gmail.comwrote: I would like to create a template whereby users could add any varialbe of items to track and the chart work for the 5 item user as well as the 9 item user. Please see the attached example. Thank you again for your dedicated help. John -- 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 excel-macros@googlegroups.com -- . -- 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 excel-macros@googlegroups.com -- 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 excel-macros@googlegroups.com -- . -- 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 excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED
Re: $$Excel-Macros$$ Chart Template Dynamic for Different Users
Excellent! I was looking into the belly of the beast to see if I could do that. Another lesson learned. Thank you Don. John On Fri, Feb 24, 2012 at 2:53 PM, dguillett1 dguille...@gmail.com wrote: Thanks for the kind words. I made a bit of improvement to not show a quarter if no values. Don Guillett SalesAid Software dguille...@gmail.com *From:* John A. Smith johnasmit...@gmail.com *Sent:* Friday, February 24, 2012 10:02 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Chart Template Dynamic for Different Users Don, I spent hours going through that spreadsheet and learned a lot. Thank you for your help and teaching. John On Thu, Feb 23, 2012 at 12:16 PM, dguillett1 dguille...@gmail.com wrote: That’s because the defined name was not referenced in the chart sources. series=smith.xls!definedname Don Guillett SalesAid Software dguille...@gmail.com *From:* John A. Smith johnasmit...@gmail.com *Sent:* Thursday, February 23, 2012 9:25 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Chart Template Dynamic for Different Users Xlstime, I saw that but when I added another product it didn't show up on the chart. John On Thu, Feb 23, 2012 at 10:20 AM, xlstime xlst...@gmail.com wrote: in Name Manager, press alt+i+n+d On Thu, Feb 23, 2012 at 8:47 PM, John A. Smith johnasmit...@gmail.comwrote: Xlstime, Where do I put that formula? John On Thu, Feb 23, 2012 at 10:10 AM, xlstime xlst...@gmail.com wrote: Dear John, Please find the attachment use formula =OFFSET($A$2,0,0,COUNTA($A$2:$A$10),COUNTA($A$2:$F$2)) On Thu, Feb 23, 2012 at 8:13 PM, John A. Smith johnasmit...@gmail.com wrote: I would like to create a template whereby users could add any varialbe of items to track and the chart work for the 5 item user as well as the 9 item user. Please see the attached example. Thank you again for your dedicated help. John -- 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 excel-macros@googlegroups.com -- . -- 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 excel-macros@googlegroups.com -- 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 excel-macros@googlegroups.com -- . -- 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
Re: $$Excel-Macros$$ Chart Template Dynamic for Different Users
Xlstime, Where do I put that formula? John On Thu, Feb 23, 2012 at 10:10 AM, xlstime xlst...@gmail.com wrote: Dear John, Please find the attachment use formula =OFFSET($A$2,0,0,COUNTA($A$2:$A$10),COUNTA($A$2:$F$2)) On Thu, Feb 23, 2012 at 8:13 PM, John A. Smith johnasmit...@gmail.comwrote: I would like to create a template whereby users could add any varialbe of items to track and the chart work for the 5 item user as well as the 9 item user. Please see the attached example. Thank you again for your dedicated help. John -- 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 excel-macros@googlegroups.com -- . -- 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 excel-macros@googlegroups.com -- 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 excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Chart Template Dynamic for Different Users
Xlstime, I saw that but when I added another product it didn't show up on the chart. John On Thu, Feb 23, 2012 at 10:20 AM, xlstime xlst...@gmail.com wrote: in Name Manager, press alt+i+n+d On Thu, Feb 23, 2012 at 8:47 PM, John A. Smith johnasmit...@gmail.comwrote: Xlstime, Where do I put that formula? John On Thu, Feb 23, 2012 at 10:10 AM, xlstime xlst...@gmail.com wrote: Dear John, Please find the attachment use formula =OFFSET($A$2,0,0,COUNTA($A$2:$A$10),COUNTA($A$2:$F$2)) On Thu, Feb 23, 2012 at 8:13 PM, John A. Smith johnasmit...@gmail.comwrote: I would like to create a template whereby users could add any varialbe of items to track and the chart work for the 5 item user as well as the 9 item user. Please see the attached example. Thank you again for your dedicated help. John -- 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 excel-macros@googlegroups.com -- . -- 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 excel-macros@googlegroups.com -- 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 excel-macros@googlegroups.com -- . -- 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 excel-macros@googlegroups.com -- 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
Re: $$Excel-Macros$$ Chart Template Dynamic for Different Users
That’s because the defined name was not referenced in the chart sources. series=smith.xls!definedname Don Guillett SalesAid Software dguille...@gmail.com From: John A. Smith Sent: Thursday, February 23, 2012 9:25 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Chart Template Dynamic for Different Users Xlstime, I saw that but when I added another product it didn't show up on the chart. John On Thu, Feb 23, 2012 at 10:20 AM, xlstime xlst...@gmail.com wrote: in Name Manager, press alt+i+n+d On Thu, Feb 23, 2012 at 8:47 PM, John A. Smith johnasmit...@gmail.com wrote: Xlstime, Where do I put that formula? John On Thu, Feb 23, 2012 at 10:10 AM, xlstime xlst...@gmail.com wrote: Dear John, Please find the attachment use formula =OFFSET($A$2,0,0,COUNTA($A$2:$A$10),COUNTA($A$2:$F$2)) On Thu, Feb 23, 2012 at 8:13 PM, John A. Smith johnasmit...@gmail.com wrote: I would like to create a template whereby users could add any varialbe of items to track and the chart work for the 5 item user as well as the 9 item user. Please see the attached example. Thank you again for your dedicated help. John -- 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 excel-macros@googlegroups.com -- . -- 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 excel-macros@googlegroups.com -- 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 excel-macros@googlegroups.com -- . -- 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