Hi
I have make it more suitable , please download from here.. http://excelpoweruser.wordpress.com/2012/09/29/showing-values-on-angle/ Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 29 September 2012 12:20 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ circular x axis in excel graph * Nice Creativity Rajan... On Sat, Sep 29, 2012 at 12:05 AM, Rajan_Verma <rajanverma1...@gmail.com> wrote: <https://www.boxbe.com/overview> Boxbe <http://www.boxbe.com/stfopen?tc=12523733031_1064418514> This message is eligible for Automatic Cleanup! (rajanverma1...@gmail.com) <https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftok en%3D1dpgyyl0KYOxyEEj6wZg0S4CzsuRC0C2FrF6bJPcxr6eYzv4jvWjpJZRziJArmzCKqRs%25 2B6uTFUDLSqUhwccXyrUSZ5kxzSFzrCYHYGMSKEvE7OBcFM63zUScD7n32KJ5WVbrPiVHROD3YJS JHZS0DQ%253D%253D%26key%3DMW3z8G4047LkKs0ZKqsh%252BpCl56jXn0IDvk609ed%252Fvy w%253D&tc=12523733031_1064418514> Add cleanup rule | <http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=12523733031_106441 8514> More info Hi Christi See the attached File . Its dynamic if you want to add more angle you can add in the yellow table ... Regards Rajan verma +91 7838100659 [IM-Gtalk] -----Original Message----- From: Rajan_Verma [mailto:rajanverma1...@gmail.com] Sent: 27 September 2012 10:19 To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ circular x axis in excel graph I am working on this . will get back to you shortly Regards Rajan verma +91 7838100659 [IM-Gtalk] -----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of David Grugeon Sent: 27 September 2012 1:58 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ circular x axis in excel graph I think you can make a list of all 360 points and leave those without data blank Regards David Grugeon On 27 September 2012 03:03, Christi Jacob <christi.ja...@gmail.com> wrote: > Hello Rajan, > the result is close to the requirement although it looks like the > radar has been rotated by some angle. > thanks > > can the graph be modified for angles which are not evenly spaced (ie > in the example the angles are spaced 45deg apart. in actual case the > first angle might be 25deg followed by 65 deg followed by 90deg...) > > regards, > christi jacob > > On Wed, Sep 26, 2012 at 8:48 PM, Rajan_Verma > <rajanverma1...@gmail.com> > wrote: >> >> Hi >> >> >> >> Not exactly same.. but I made something J >> >> >> >> See the attached >> >> >> >> >> >> Regards >> >> Rajan verma >> >> +91 7838100659 [IM-Gtalk] >> >> >> >> From: excel-macros@googlegroups.com >> [mailto:excel-macros@googlegroups.com] >> On Behalf Of Christi Jacob >> Sent: 26 September 2012 7:09 >> >> >> To: excel-macros@googlegroups.com >> Subject: Re: $$Excel-Macros$$ circular x axis in excel graph >> >> >> >> Dear friends, >> >> i am attaching a image file of the expected graph >> >> note: instead of radial line i actually require a curve through the points >> as shown in the image file ( :( ) >> >> >> >> also the number of data points may be 8, 10, 20 etc in various cases >> >> hence if it is possible to automate it it will be good >> >> >> >> thanks >> >> christi jacob >> >> On Wed, Sep 26, 2012 at 6:03 AM, David Grugeon <da...@grugeon.com.au> >> wrote: >> >> See attachment for the sort of chart required. >> >> >> Regards >> David Grugeon >> >> >> >> On 26 September 2012 10:22, David Grugeon <da...@grugeon.com.au> wrote: >> > There is an explanation how to do it and a very useful sample >> > workbook download at this site >> > >> > http://www.ozgrid.com/Excel/polar-plot-chart.htm >> > >> > >> > Regards >> > David Grugeon >> > >> > >> > On 26 September 2012 09:56, David Grugeon <da...@grugeon.com.au> wrote: >> >> I do not know of a chat type in excel that does what you want >> >> directly. Since you only have 8 data points (360 is the same as 0 >> >> so can be ignored) you could do it by making 8 doughnut charts and >> >> putting them on top of each other. Clunky, I know, but it is >> >> probably better than trying to plot the 8 points and join them >> >> each to 0,0 coordinate. Turtle Graphics anyone? >> >> >> >> Regards >> >> David Grugeon >> >> >> >> >> >> On 26 September 2012 05:41, Sam Mathai Chacko <samde...@gmail.com> >> >> wrote: >> >>> maybe you can draw a sample in paint and post it so that people >> >>> understand what exactly you are looking for in the chart. >> >>> >> >>> >> >>> On Wed, Sep 26, 2012 at 1:06 AM, Christi Jacob >> >>> <christi.ja...@gmail.com> >> >>> wrote: >> >>>> >> >>>> Dear friends, >> >>>> this is my first query to this group i am having a data which >> >>>> may be as follows >> >>>> angle strength >> >>>> 0 10 >> >>>> 45 20 >> >>>> 90 30 >> >>>> 135 20 >> >>>> 180 0 >> >>>> 225 20 >> >>>> 270 30 >> >>>> 315 20 >> >>>> 360 10 >> >>>> >> >>>> the values under heading angle are in degrees i would like to >> >>>> plot them in a graph such that the independent axis shows up on >> >>>> a circle as angular location and strength value shows up as >> >>>> radial lines >> >>>> >> >>>> Please guide >> >>>> >> >>>> regards, >> >>>> christi jacob >> >>>> >> >>>> >> >>>> -- >> >>>> Join official facebook page of this forum @ >> >>>> https://www.facebook.com/discussexcel >> >>>> >> >>>> FORUM RULES (1120+ 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. >> >>>> >> >>>> 6) Jobs posting is not allowed. >> >>>> >> >>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not >> >>>> allowed. >> >>>> >> >>>> NOTE : Don't ever post personal or confidential data in a workbook. >> >>>> Forum >> >>>> owners and members are not responsible for any loss. >> >>>> --- >> >>>> You received this message because you are subscribed to the >> >>>> Google Groups "MS EXCEL AND VBA MACROS" group. >> >>>> To post to this group, send email to excel-macros@googlegroups.com. >> >>>> To unsubscribe from this group, send email to >> >>>> excel-macros+unsubscr...@googlegroups.com <mailto:excel-macros%2bunsubscr...@googlegroups.com> . >> >>>> >> >>>> >> >>> >> >>> >> >>> >> >>> >> >>> -- >> >>> Sam Mathai Chacko >> >>> >> >>> -- >> >>> Join official facebook page of this forum @ >> >>> https://www.facebook.com/discussexcel >> >>> >> >>> FORUM RULES (1120+ 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. >> >>> >> >>> 6) Jobs posting is not allowed. >> >>> >> >>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not >> >>> allowed. >> >>> >> >>> NOTE : Don't ever post personal or confidential data in a workbook. >> >>> Forum >> >>> owners and members are not responsible for any loss. >> >>> --- >> >>> You received this message because you are subscribed to the >> >>> Google Groups "MS EXCEL AND VBA MACROS" group. >> >>> To post to this group, send email to excel-macros@googlegroups.com. >> >>> To unsubscribe from this group, send email to >> >>> excel-macros+unsubscr...@googlegroups.com <mailto:excel-macros%2bunsubscr...@googlegroups.com> . >> >>> >> >>> >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ 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. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or confidential data in a workbook. >> Forum owners and members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google >> Groups "MS EXCEL AND VBA MACROS" group. >> To post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com <mailto:excel-macros%2bunsubscr...@googlegroups.com> . >> >> >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ 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. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or confidential data in a workbook. >> Forum owners and members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google >> Groups "MS EXCEL AND VBA MACROS" group. >> To post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com <mailto:excel-macros%2bunsubscr...@googlegroups.com> . >> >> >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ 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. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or confidential data in a workbook. >> Forum owners and members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google >> Groups "MS EXCEL AND VBA MACROS" group. >> To post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com <mailto:excel-macros%2bunsubscr...@googlegroups.com> . >> >> > > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ 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. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. > Forum owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google > Groups "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com <mailto:excel-macros%2bunsubscr...@googlegroups.com> . > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com <mailto:excel-macros%2bunsubscr...@googlegroups.com> . -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com <mailto:excel-macros%2bunsubscr...@googlegroups.com> . -- With Regards, Noorain Ansari <http://www.noorainansari.com> http://noorainansari.com <http://www.noorainansari.com> <http://www.excelvbaclinic.blogspot.com> http://excelvbaclinic.com <http://www.excelvbaclinic.blogspot.com> -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
