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 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 > 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&tc=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 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 > > > > 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 > >> wrote: > >> > >> See attachment for the sort of chart required. > >> > >> > >> Regards > >> David Grugeon > >> > >> > >> > >> On 26 September 2012 10:22, David Grugeon wrote: > >> > There is an explanation how to do it and a very useful sample > >> >
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 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.
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 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 > 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 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 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 >> 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 t
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 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 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 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 >>> >>> 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 re
Re: $$Excel-Macros$$ circular x axis in excel graph
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 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 > wrote: > > See attachment for the sort of chart required. > > > Regards > David Grugeon > > > > On 26 September 2012 10:22, David Grugeon 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 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 > 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
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 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 > 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 >> wrote: >> >> See attachment for the sort of chart required. >> >> >> Regards >> David Grugeon >> >> >> >> On 26 September 2012 10:22, David Grugeon 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 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 >> >> 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 >> >>> >> >>> 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 titl
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 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 > > 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 >> wrote: >> >> See attachment for the sort of chart required. >> >> >> Regards >> David Grugeon >> >> >> >> On 26 September 2012 10:22, David Grugeon 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 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 >> >> 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 >> >>> >> >>> 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 >> >>>> >> >>>> >> >>>> -- >> >>&
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 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 > > 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 >> wrote: >> >> See attachment for the sort of chart required. >> >> >> Regards >> David Grugeon >> >> >> >> On 26 September 2012 10:22, David Grugeon 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 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 >> >> 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 >> >>> >> >>> 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
Re: $$Excel-Macros$$ circular x axis in excel graph *
Nice Creativity Rajan... On Sat, Sep 29, 2012 at 12:05 AM, Rajan_Verma 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&tc=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 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 > > > > 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 > >> wrote: > >> > >> See attachment for the sort of chart required. > >> > >> > >> Regards > >> David Grugeon > >> > >> > >> > >> On 26 September 2012 10:22, David Grugeon 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 > 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
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 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 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 > > 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 >> wrote: >> >> See attachment for the sort of chart required. >> >> >> Regards >> David Grugeon >> >> >> >> On 26 September 2012 10:22, David Grugeon 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 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 >>
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 wrote: > Nice Creativity Rajan... > > On Sat, Sep 29, 2012 at 12:05 AM, Rajan_Verma 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&tc=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 >> 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 >> > >> > 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 >> >> wrote: >> >> >> >> See attachment for the sort of chart required. >> >> >> >> >> >> Regards >> >> David Grugeon >> >> >> >> >> >> >> >> On 26 September 2012 10:22, David Grugeon >> 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-plo
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 wrote: > 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 > wrote: > >> Nice Creativity Rajan... >> >> On Sat, Sep 29, 2012 at 12:05 AM, Rajan_Verma >> 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&tc=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 >>> 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 >>> > >>> > 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 >>> >> >>> >> >>> >> >