I think you can make a list of all 360 points and leave those without data blank Regards David Grugeon
On 27 September 2012 03:03, Christi Jacob <christi.ja...@gmail.com> wrote: > Hello Rajan, > the result is close to the requirement although it looks like the radar has > been rotated by some angle. > thanks > > can the graph be modified for angles which are not evenly spaced > (ie in the example the angles are spaced 45deg apart. in actual case the > first angle might be 25deg followed by 65 deg followed by 90deg...) > > regards, > christi jacob > > On Wed, Sep 26, 2012 at 8:48 PM, Rajan_Verma <rajanverma1...@gmail.com> > wrote: >> >> Hi >> >> >> >> Not exactly same.. but I made something J >> >> >> >> See the attached >> >> >> >> >> >> Regards >> >> Rajan verma >> >> +91 7838100659 [IM-Gtalk] >> >> >> >> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] >> On Behalf Of Christi Jacob >> Sent: 26 September 2012 7:09 >> >> >> To: excel-macros@googlegroups.com >> Subject: Re: $$Excel-Macros$$ circular x axis in excel graph >> >> >> >> Dear friends, >> >> i am attaching a image file of the expected graph >> >> note: instead of radial line i actually require a curve through the points >> as shown in the image file ( :( ) >> >> >> >> also the number of data points may be 8, 10, 20 etc in various cases >> >> hence if it is possible to automate it it will be good >> >> >> >> thanks >> >> christi jacob >> >> On Wed, Sep 26, 2012 at 6:03 AM, David Grugeon <da...@grugeon.com.au> >> wrote: >> >> See attachment for the sort of chart required. >> >> >> Regards >> David Grugeon >> >> >> >> On 26 September 2012 10:22, David Grugeon <da...@grugeon.com.au> wrote: >> > There is an explanation how to do it and a very useful sample workbook >> > download at this site >> > >> > http://www.ozgrid.com/Excel/polar-plot-chart.htm >> > >> > >> > Regards >> > David Grugeon >> > >> > >> > On 26 September 2012 09:56, David Grugeon <da...@grugeon.com.au> wrote: >> >> I do not know of a chat type in excel that does what you want >> >> directly. Since you only have 8 data points (360 is the same as 0 so >> >> can be ignored) you could do it by making 8 doughnut charts and >> >> putting them on top of each other. Clunky, I know, but it is probably >> >> better than trying to plot the 8 points and join them each to 0,0 >> >> coordinate. Turtle Graphics anyone? >> >> >> >> Regards >> >> David Grugeon >> >> >> >> >> >> On 26 September 2012 05:41, Sam Mathai Chacko <samde...@gmail.com> >> >> wrote: >> >>> maybe you can draw a sample in paint and post it so that people >> >>> understand >> >>> what exactly you are looking for in the chart. >> >>> >> >>> >> >>> On Wed, Sep 26, 2012 at 1:06 AM, Christi Jacob >> >>> <christi.ja...@gmail.com> >> >>> wrote: >> >>>> >> >>>> Dear friends, >> >>>> this is my first query to this group >> >>>> i am having a data which may be as follows >> >>>> angle strength >> >>>> 0 10 >> >>>> 45 20 >> >>>> 90 30 >> >>>> 135 20 >> >>>> 180 0 >> >>>> 225 20 >> >>>> 270 30 >> >>>> 315 20 >> >>>> 360 10 >> >>>> >> >>>> the values under heading angle are in degrees >> >>>> i would like to plot them in a graph such that the independent axis >> >>>> shows >> >>>> up on a circle as angular location and strength value shows up as >> >>>> radial >> >>>> lines >> >>>> >> >>>> Please guide >> >>>> >> >>>> regards, >> >>>> christi jacob >> >>>> >> >>>> >> >>>> -- >> >>>> Join official facebook page of this forum @ >> >>>> https://www.facebook.com/discussexcel >> >>>> >> >>>> FORUM RULES (1120+ members already BANNED for violation) >> >>>> >> >>>> 1) Use concise, accurate thread titles. Poor thread titles, like >> >>>> Please >> >>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >> >>>> Advice will >> >>>> not get quick attention or may not be answered. >> >>>> >> >>>> 2) Don't post a question in the thread of another member. >> >>>> >> >>>> 3) Don't post questions regarding breaking or bypassing any security >> >>>> measure. >> >>>> >> >>>> 4) Acknowledge the responses you receive, good or bad. >> >>>> >> >>>> 5) Cross-promotion of, or links to, forums competitive to this forum >> >>>> in >> >>>> signatures are prohibited. >> >>>> >> >>>> 6) Jobs posting is not allowed. >> >>>> >> >>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not >> >>>> allowed. >> >>>> >> >>>> NOTE : Don't ever post personal or confidential data in a workbook. >> >>>> Forum >> >>>> owners and members are not responsible for any loss. >> >>>> --- >> >>>> You received this message because you are subscribed to the Google >> >>>> Groups >> >>>> "MS EXCEL AND VBA MACROS" group. >> >>>> To post to this group, send email to excel-macros@googlegroups.com. >> >>>> To unsubscribe from this group, send email to >> >>>> excel-macros+unsubscr...@googlegroups.com. >> >>>> >> >>>> >> >>> >> >>> >> >>> >> >>> >> >>> -- >> >>> 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. >> >> >> >> -- >> 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. >> >> > > > -- > 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.
