 |
 |
 |
 |
 |
|
|
||||||||||||
|
#1
11-01-2005, 01:05 AM
|
|||
|
|||
|
Polar chart... how
Hello
How can I make a polar chart? Seems like such a fundamental object yet virtually impossible in MS Excel.. any ideas...examples ... help Thank you Ralph 
|
|
#2
11-01-2005, 07:05 AM
|
|||
|
|||
|
Re: Polar chart... how
Andy Pope has an add in here.
http://www.andypope.info/charts/polarplot.htm "Ralph2" <nonefound@hotmail.com> wrote in message news:obtdm1lp2vk077fs0lgdcvgnsbi8u9gtts@4ax.com... > Hello > > How can I make a polar chart? Seems like such a fundamental object > yet virtually impossible in MS Excel.. > > any ideas...examples ... help > Thank you > Ralph >
|
|
#3
11-02-2005, 06:17 PM
|
|||
|
|||
|
Re: Polar chart... how
On Tue, 1 Nov 2005 05:12:20 -0500, "Barb Reinhardt"
<reply@tonewsgroup.com> wrote: >Andy Pope has an add in here. > >http://www.andypope.info/charts/polarplot.htm > >"Ralph2" <nonefound@hotmail.com> wrote in message >news:obtdm1lp2vk077fs0lgdcvgnsbi8u9gtts@4ax.com... >> Hello >> >> How can I make a polar chart? Seems like such a fundamental object >> yet virtually impossible in MS Excel.. >> >> any ideas...examples ... help >> Thank you >> Ralph >> > Thank you.. have that one.. My concern is that "if" I use an add-in then I will have to add that to all the computers that may end up using this.. Would prefer to stay with a native Excel
|
|
#4
11-02-2005, 06:17 PM
|
|||
|
|||
|
Re: Polar chart... how
Hi Ralph,
The addin only makes it easier by generating the x and y values and creating the chart with appropriate series. The addin is not locked so you can see how I have done things and maybe transfer the code into cell formula. Cheers Andy Ralph2 wrote: > On Tue, 1 Nov 2005 05:12:20 -0500, "Barb Reinhardt" > <reply@tonewsgroup.com> wrote: > > >>Andy Pope has an add in here. >> >>http://www.andypope.info/charts/polarplot.htm >> >>"Ralph2" <nonefound@hotmail.com> wrote in message >>news:obtdm1lp2vk077fs0lgdcvgnsbi8u9gtts@4ax.com... >> >>>Hello >>> >>>How can I make a polar chart? Seems like such a fundamental object >>>yet virtually impossible in MS Excel.. >>> >>>any ideas...examples ... help >>>Thank you >>>Ralph >>> >> > Thank you.. have that one.. My concern is that "if" I use an add-in > then I will have to add that to all the computers that may end up > using this.. Would prefer to stay with a native Excel -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info
|
|
#5
11-02-2005, 06:17 PM
|
|||
|
|||
|
Re: Polar chart... how
In article <mr8gm1plnijfbd8vi9hn2tdf6srijesmh5@4ax.com>,
nonefound@hotmail.com says... > > > Thank you.. have that one.. My concern is that "if" I use an add-in > then I will have to add that to all the computers that may end up > using this.. Would prefer to stay with a native Excel > Valid concerns except that as Andy himself pointed out the add-in is needed only to create the chart(s). To do it yourself, since XL doesn't natively support polar plots (or other parametric plots), consider the tranformation between (x,y) and (r,theta) x=r*cos(theta) and y=r*sin(theta) where theta is measured in radians. -- Regards, Tushar Mehta www.tushar-mehta.com Multi-disciplinary business expertise + Technology skills = Optimal solution to your business problem Recipient Microsoft MVP award 2000-2005 In article <mr8gm1plnijfbd8vi9hn2tdf6srijesmh5@4ax.com>, nonefound@hotmail.com says... > On Tue, 1 Nov 2005 05:12:20 -0500, "Barb Reinhardt" > <reply@tonewsgroup.com> wrote: > > >Andy Pope has an add in here. > > > >http://www.andypope.info/charts/polarplot.htm > > > >"Ralph2" <nonefound@hotmail.com> wrote in message > >news:obtdm1lp2vk077fs0lgdcvgnsbi8u9gtts@4ax.com... > >> Hello > >> > >> How can I make a polar chart? Seems like such a fundamental object > >> yet virtually impossible in MS Excel.. > >> > >> any ideas...examples ... help > >> Thank you > >> Ralph > >> > > > Thank you.. have that one.. My concern is that "if" I use an add-in > then I will have to add that to all the computers that may end up > using this.. Would prefer to stay with a native Excel >
|
|
#6
11-02-2005, 06:20 PM
|
|||
|
|||
|
Re: Polar chart... how
On Tue, 1 Nov 2005 05:12:20 -0500, "Barb Reinhardt"
<reply@tonewsgroup.com> wrote: >Andy Pope has an add in here. > >http://www.andypope.info/charts/polarplot.htm > >"Ralph2" <nonefound@hotmail.com> wrote in message >news:obtdm1lp2vk077fs0lgdcvgnsbi8u9gtts@4ax.com... >> Hello >> >> How can I make a polar chart? Seems like such a fundamental object >> yet virtually impossible in MS Excel.. >> >> any ideas...examples ... help >> Thank you >> Ralph >> > Thank you.. have that one.. My concern is that "if" I use an add-in then I will have to add that to all the computers that may end up using this.. Would prefer to stay with a native Excel
|
|
#7
11-02-2005, 06:20 PM
|
|||
|
|||
|
Re: Polar chart... how
Hi Ralph,
The addin only makes it easier by generating the x and y values and creating the chart with appropriate series. The addin is not locked so you can see how I have done things and maybe transfer the code into cell formula. Cheers Andy Ralph2 wrote: > On Tue, 1 Nov 2005 05:12:20 -0500, "Barb Reinhardt" > <reply@tonewsgroup.com> wrote: > > >>Andy Pope has an add in here. >> >>http://www.andypope.info/charts/polarplot.htm >> >>"Ralph2" <nonefound@hotmail.com> wrote in message >>news:obtdm1lp2vk077fs0lgdcvgnsbi8u9gtts@4ax.com... >> >>>Hello >>> >>>How can I make a polar chart? Seems like such a fundamental object >>>yet virtually impossible in MS Excel.. >>> >>>any ideas...examples ... help >>>Thank you >>>Ralph >>> >> > Thank you.. have that one.. My concern is that "if" I use an add-in > then I will have to add that to all the computers that may end up > using this.. Would prefer to stay with a native Excel -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info
|
|
#8
11-02-2005, 06:20 PM
|
|||
|
|||
|
Re: Polar chart... how
In article <mr8gm1plnijfbd8vi9hn2tdf6srijesmh5@4ax.com>,
nonefound@hotmail.com says... > > > Thank you.. have that one.. My concern is that "if" I use an add-in > then I will have to add that to all the computers that may end up > using this.. Would prefer to stay with a native Excel > Valid concerns except that as Andy himself pointed out the add-in is needed only to create the chart(s). To do it yourself, since XL doesn't natively support polar plots (or other parametric plots), consider the tranformation between (x,y) and (r,theta) x=r*cos(theta) and y=r*sin(theta) where theta is measured in radians. -- Regards, Tushar Mehta www.tushar-mehta.com Multi-disciplinary business expertise + Technology skills = Optimal solution to your business problem Recipient Microsoft MVP award 2000-2005 In article <mr8gm1plnijfbd8vi9hn2tdf6srijesmh5@4ax.com>, nonefound@hotmail.com says... > On Tue, 1 Nov 2005 05:12:20 -0500, "Barb Reinhardt" > <reply@tonewsgroup.com> wrote: > > >Andy Pope has an add in here. > > > >http://www.andypope.info/charts/polarplot.htm > > > >"Ralph2" <nonefound@hotmail.com> wrote in message > >news:obtdm1lp2vk077fs0lgdcvgnsbi8u9gtts@4ax.com... > >> Hello > >> > >> How can I make a polar chart? Seems like such a fundamental object > >> yet virtually impossible in MS Excel.. > >> > >> any ideas...examples ... help > >> Thank you > >> Ralph > >> > > > Thank you.. have that one.. My concern is that "if" I use an add-in > then I will have to add that to all the computers that may end up > using this.. Would prefer to stay with a native Excel >
|
|
#9
11-02-2005, 10:00 PM
|
|||
|
|||
|
Re: Polar chart... how
Thanks Andy
I was going to try that.. will contact you on your home page if I end up using your bits of your code. Interested in a project to add to your selection... ....Limited clientele but As I found out in the Eng-Tips forum several people have tried and given up. Ralph On Wed, 02 Nov 2005 09:19:32 +0000, Andy Pope <andy@andypope.info> wrote: >Hi Ralph, > >The addin only makes it easier by generating the x and y values and >creating the chart with appropriate series. The addin is not locked so >you can see how I have done things and maybe transfer the code into cell >formula. > >Cheers >Andy > >Ralph2 wrote: >> On Tue, 1 Nov 2005 05:12:20 -0500, "Barb Reinhardt" >> <reply@tonewsgroup.com> wrote: >> >> >>>Andy Pope has an add in here. >>> >>>http://www.andypope.info/charts/polarplot.htm >>> >>>"Ralph2" <nonefound@hotmail.com> wrote in message >>>news:obtdm1lp2vk077fs0lgdcvgnsbi8u9gtts@4ax.com... >>> >>>>Hello >>>> >>>>How can I make a polar chart? Seems like such a fundamental object >>>>yet virtually impossible in MS Excel.. >>>> >>>>any ideas...examples ... help >>>>Thank you >>>>Ralph >>>> >>> >> Thank you.. have that one.. My concern is that "if" I use an add-in >> then I will have to add that to all the computers that may end up >> using this.. Would prefer to stay with a native Excel
|
|
#10
11-03-2005, 12:15 AM
|
|||
|
|||
|
Re: Polar chart... how
I'm late to the dance, but Stephen Bullen has an annotated example on
his web site: http://www.oaltd.co.uk/DLCount/DLCou...e=FunChrt6.zip "This chart shows how to create polar plots in Excel. It uses one set of defined names to dynamically refer to the data points entered (so new points are automatically included in the chart) and a second set to perform the conversion from polar to cartesian coordinates, which are then plotted using a standard XY chart." - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Ralph2 wrote: > Hello > > How can I make a polar chart? Seems like such a fundamental object > yet virtually impossible in MS Excel.. > > any ideas...examples ... help > Thank you > Ralph >
|
|
#11
11-03-2005, 08:25 AM
|
|||
|
|||
|
Re: Polar chart... how
In article <3crim1d0i4m5e8uieieaeshe99290fifpl@4ax.com>,
nonefound@hotmail.com says... > your selection... ....Limited clientele but As I found out in the > Eng-Tips forum several people have tried and given up. > That is strange. Polar charts are not rocket science. I have an add-in similar to Andy's and a tutorial on parametric charts, neither of which I have got around to putting on my web site. But, bottom line, mapping (x,y) or (x,y,z) to (r,theta) or (r,theta,phi) uses basic rules of trig established a long time ago. -- Regards, Tushar Mehta www.tushar-mehta.com Multi-disciplinary business expertise + Technology skills = Optimal solution to your business problem Recipient Microsoft MVP award 2000-2005 In article <3crim1d0i4m5e8uieieaeshe99290fifpl@4ax.com>, nonefound@hotmail.com says... > Thanks Andy > I was going to try that.. will contact you on your home page if I end > up using your bits of your code. Interested in a project to add to > your selection... ....Limited clientele but As I found out in the > Eng-Tips forum several people have tried and given up. > > Ralph > On Wed, 02 Nov 2005 09:19:32 +0000, Andy Pope <andy@andypope.info> > wrote: > > >Hi Ralph, > > > >The addin only makes it easier by generating the x and y values and > >creating the chart with appropriate series. The addin is not locked so > >you can see how I have done things and maybe transfer the code into cell > >formula. > > > >Cheers > >Andy > > > >Ralph2 wrote: > >> On Tue, 1 Nov 2005 05:12:20 -0500, "Barb Reinhardt" > >> <reply@tonewsgroup.com> wrote: > >> > >> > >>>Andy Pope has an add in here. > >>> > >>>http://www.andypope.info/charts/polarplot.htm > >>> > >>>"Ralph2" <nonefound@hotmail.com> wrote in message > >>>news:obtdm1lp2vk077fs0lgdcvgnsbi8u9gtts@4ax.com... > >>> > >>>>Hello > >>>> > >>>>How can I make a polar chart? Seems like such a fundamental object > >>>>yet virtually impossible in MS Excel.. > >>>> > >>>>any ideas...examples ... help > >>>>Thank you > >>>>Ralph > >>>> > >>> > >> Thank you.. have that one.. My concern is that "if" I use an add-in > >> then I will have to add that to all the computers that may end up > >> using this.. Would prefer to stay with a native Excel > >
|
|
#12
11-03-2005, 08:30 AM
|
|||
|
|||
|
Re: Polar chart... how
You may also want to look at Stephen Bullen's web site. See
FunChrt6.zip at http://www.oaltd.co.uk/Excel/SBXLPage.asp#Charting -- Regards, Tushar Mehta www.tushar-mehta.com Multi-disciplinary business expertise + Technology skills = Optimal solution to your business problem Recipient Microsoft MVP award 2000-2005 In article <3crim1d0i4m5e8uieieaeshe99290fifpl@4ax.com>, nonefound@hotmail.com says... > Thanks Andy > I was going to try that.. will contact you on your home page if I end > up using your bits of your code. Interested in a project to add to > your selection... ....Limited clientele but As I found out in the > Eng-Tips forum several people have tried and given up. > > Ralph > On Wed, 02 Nov 2005 09:19:32 +0000, Andy Pope <andy@andypope.info> > wrote: > > >Hi Ralph, > > > >The addin only makes it easier by generating the x and y values and > >creating the chart with appropriate series. The addin is not locked so > >you can see how I have done things and maybe transfer the code into cell > >formula. > > > >Cheers > >Andy > > > >Ralph2 wrote: > >> On Tue, 1 Nov 2005 05:12:20 -0500, "Barb Reinhardt" > >> <reply@tonewsgroup.com> wrote: > >> > >> > >>>Andy Pope has an add in here. > >>> > >>>http://www.andypope.info/charts/polarplot.htm > >>> > >>>"Ralph2" <nonefound@hotmail.com> wrote in message > >>>news:obtdm1lp2vk077fs0lgdcvgnsbi8u9gtts@4ax.com... > >>> > >>>>Hello > >>>> > >>>>How can I make a polar chart? Seems like such a fundamental object > >>>>yet virtually impossible in MS Excel.. > >>>> > >>>>any ideas...examples ... help > >>>>Thank you > >>>>Ralph > >>>> > >>> > >> Thank you.. have that one.. My concern is that "if" I use an add-in > >> then I will have to add that to all the computers that may end up > >> using this.. Would prefer to stay with a native Excel > >
|
|
#13
11-03-2005, 02:25 PM
|
|||
|
|||
|
Re: Polar chart... how
See also http://www.stfx.ca/people/bliengme/ExcelTips/Polar.htm
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Ralph2" <nonefound@hotmail.com> wrote in message news:obtdm1lp2vk077fs0lgdcvgnsbi8u9gtts@4ax.com... > Hello > > How can I make a polar chart? Seems like such a fundamental object > yet virtually impossible in MS Excel.. > > any ideas...examples ... help > Thank you > Ralph >
|
|
#14
11-03-2005, 10:25 PM
|
|||
|
|||
|
Re: Polar chart... how
Thanks for all the links to samples... Very much appreciated. Now if
I can clear the cobwebs and recall some of that geometry I learned 40 years ago.. Ralph
|
|
#15
12-14-2005, 05:10 PM
|
|||
|
|||
|
RE: Polar chart... how
I placed a posting a while ago about this same subject. One of you had given
me a *.exec that I could run to place labels on my axes. My computer crashed and I no longer have that macro. Does this ring a bell? "Ralph2" wrote: > Hello > > How can I make a polar chart? Seems like such a fundamental object > yet virtually impossible in MS Excel.. > > any ideas...examples ... help > Thank you > Ralph > >
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
