Re: $$Excel-Macros$$ circular x axis in excel graph *
Hi Rajan / vba gurus, If possible please share this file as I have a similar issue http://excelpoweruser.wordpress.com/2012/09/29/showing-values-on-angle/ On Sat, Sep 29, 2012 at 5:01 PM, Rajan_Verma <rajanverma1...@gmail.com> wrote: > > > *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: > > [image: Boxbe] <https://www.boxbe.com/overview>This message is eligible > for Automatic Cleanup! (rajanverma1...@gmail.com) Add cleanup rule > <https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D1dpgyyl0KYOxyEEj6wZg0S4CzsuRC0C2FrF6bJPcxr6eYzv4jvWjpJZRziJArmzCKqRs%252B6uTFUDLSqUhwccXyrUSZ5kxzSFzrCYHYGMSKEvE7OBcFM63zUScD7n32KJ5WVbrPiVHROD3YJSJHZS0DQ%253D%253D%26key%3DMW3z8G4047LkKs0ZKqsh%252BpCl56jXn0IDvk609ed%252Fvyw%253D=12523733031_1064418514> > | More info > <http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=12523733031_1064418514> > > > 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 Septem
RE: $$Excel-Macros$$ circular x axis in excel graph *
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%253Dtc=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 anglestrength 0 10 45 20 90 30 13520 1800 22520 27030 31520 36010 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
Re: $$Excel-Macros$$ circular x axis in excel graph *
Hello Rajan, Thanks! This will solve my problem for the time being Regards, Christi Jacob On Sat, Sep 29, 2012 at 12:19 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Nice Creativity Rajan... On Sat, Sep 29, 2012 at 12:05 AM, Rajan_Verma rajanverma1...@gmail.comwrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (rajanverma1...@gmail.com) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D1dpgyyl0KYOxyEEj6wZg0S4CzsuRC0C2FrF6bJPcxr6eYzv4jvWjpJZRziJArmzCKqRs%252B6uTFUDLSqUhwccXyrUSZ5kxzSFzrCYHYGMSKEvE7OBcFM63zUScD7n32KJ5WVbrPiVHROD3YJSJHZS0DQ%253D%253D%26key%3DMW3z8G4047LkKs0ZKqsh%252BpCl56jXn0IDvk609ed%252Fvyw%253Dtc=12523733031_1064418514| More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=12523733031_1064418514 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 anglestrength 0 10 45 20 90 30 13520 1800 22520 27030 31520 36010 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
Re: $$Excel-Macros$$ circular x axis in excel graph *
RajanU rocks... Thanks Regards, Vikash Chandra Statistical Analyst 9902622922 On Sun, Sep 30, 2012 at 1:30 AM, Christi Jacob christi.ja...@gmail.comwrote: Hello Rajan, Thanks! This will solve my problem for the time being Regards, Christi Jacob On Sat, Sep 29, 2012 at 12:19 AM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Nice Creativity Rajan... On Sat, Sep 29, 2012 at 12:05 AM, Rajan_Verma rajanverma1...@gmail.comwrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (rajanverma1...@gmail.com) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D1dpgyyl0KYOxyEEj6wZg0S4CzsuRC0C2FrF6bJPcxr6eYzv4jvWjpJZRziJArmzCKqRs%252B6uTFUDLSqUhwccXyrUSZ5kxzSFzrCYHYGMSKEvE7OBcFM63zUScD7n32KJ5WVbrPiVHROD3YJSJHZS0DQ%253D%253D%26key%3DMW3z8G4047LkKs0ZKqsh%252BpCl56jXn0IDvk609ed%252Fvyw%253Dtc=12523733031_1064418514| More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=12523733031_1064418514 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 anglestrength 0 10 45 20 90 30 13520 1800 22520 27030 31520 36010 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
Re: $$Excel-Macros$$ circular x axis in excel graph
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 anglestrength 0 10 45 20 90 30 13520 1800 22520 27030 31520 36010 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
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.comwrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (rajanverma1...@gmail.com) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D1dpgyyl0KYOxyEEj6wZg0S4CzsuRC0C2FrF6bJPcxr6eYzv4jvWjpJZRziJArmzCKqRs%252B6uTFUDLSqUhwccXyrUSZ5kxzSFzrCYHYGMSKEvE7OBcFM63zUScD7n32KJ5WVbrPiVHROD3YJSJHZS0DQ%253D%253D%26key%3DMW3z8G4047LkKs0ZKqsh%252BpCl56jXn0IDvk609ed%252Fvyw%253Dtc=12523733031_1064418514| More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=12523733031_1064418514 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 anglestrength 0 10 45 20 90 30 13520 1800 22520 27030 31520 36010 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
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 anglestrength 0 10 45 20 90 30 13520 1800 22520 27030 31520 36010 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. -- 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
RE: $$Excel-Macros$$ circular x axis in excel graph
Nice 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: 26 September 2012 6:04 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ circular x axis in excel graph 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 anglestrength 0 10 45 20 90 30 13520 1800 22520 27030 31520 36010 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. -- 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. -- 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
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 anglestrength 0 10 45 20 90 30 13520 1800 22520 27030 31520 36010 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. -- 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
$$Excel-Macros$$ circular x axis in excel graph
Dear friends, this is my first query to this group i am having a data which may be as follows anglestrength 0 10 45 20 90 30 13520 1800 22520 27030 31520 36010 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.
Re: $$Excel-Macros$$ circular x axis in excel graph
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.comwrote: Dear friends, this is my first query to this group i am having a data which may be as follows anglestrength 0 10 45 20 90 30 13520 1800 22520 27030 31520 36010 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. -- 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.
Re: $$Excel-Macros$$ circular x axis in excel graph
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 anglestrength 0 10 45 20 90 30 13520 1800 22520 27030 31520 36010 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. -- 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. -- 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.
Re: $$Excel-Macros$$ circular x axis in excel graph
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 anglestrength 0 10 45 20 90 30 13520 1800 22520 27030 31520 36010 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. -- 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. -- 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.
