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

Andy Pope has an add in here.

http://www.andypope.info/charts/polarplot.htm

"Ralph2" <[email protected]> wrote in message
news:[email protected]...
> 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
>

On Tue, 1 Nov 2005 05:12:20 -0500, "Barb Reinhardt"
<[email protected]> wrote:

>Andy Pope has an add in here.
>
>http://www.andypope.info/charts/polarplot.htm
>
>"Ralph2" <[email protected]> wrote in message
>news:[email protected]...
>> 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

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"
> <[email protected]> wrote:
>
>
>>Andy Pope has an add in here.
>>
>>http://www.andypope.info/charts/polarplot.htm
>>
>>"Ralph2" <[email protected]> wrote in message
>>news:[email protected]...
>>
>>>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

In article <[email protected]>,
[email protected] 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 <[email protected]>,
[email protected] says...
> On Tue, 1 Nov 2005 05:12:20 -0500, "Barb Reinhardt"
> <[email protected]> wrote:
>
> >Andy Pope has an add in here.
> >
> >http://www.andypope.info/charts/polarplot.htm
> >
> >"Ralph2" <[email protected]> wrote in message
> >news:[email protected]...
> >> 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
>

On Tue, 1 Nov 2005 05:12:20 -0500, "Barb Reinhardt"
<[email protected]> wrote:

>Andy Pope has an add in here.
>
>http://www.andypope.info/charts/polarplot.htm
>
>"Ralph2" <[email protected]> wrote in message
>news:[email protected]...
>> 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

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"
> <[email protected]> wrote:
>
>
>>Andy Pope has an add in here.
>>
>>http://www.andypope.info/charts/polarplot.htm
>>
>>"Ralph2" <[email protected]> wrote in message
>>news:[email protected]...
>>
>>>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

In article <[email protected]>,
[email protected] 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 <[email protected]>,
[email protected] says...
> On Tue, 1 Nov 2005 05:12:20 -0500, "Barb Reinhardt"
> <[email protected]> wrote:
>
> >Andy Pope has an add in here.
> >
> >http://www.andypope.info/charts/polarplot.htm
> >
> >"Ralph2" <[email protected]> wrote in message
> >news:[email protected]...
> >> 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
>

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 <[email protected]>
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"
>> <[email protected]> wrote:
>>
>>
>>>Andy Pope has an add in here.
>>>
>>>http://www.andypope.info/charts/polarplot.htm
>>>
>>>"Ralph2" <[email protected]> wrote in message
>>>news:[email protected]...
>>>
>>>>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

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
>

In article <[email protected]>,
[email protected] 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 <[email protected]>,
[email protected] 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 <[email protected]>
> 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"
> >> <[email protected]> wrote:
> >>
> >>
> >>>Andy Pope has an add in here.
> >>>
> >>>http://www.andypope.info/charts/polarplot.htm
> >>>
> >>>"Ralph2" <[email protected]> wrote in message
> >>>news:[email protected]...
> >>>
> >>>>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
>
>

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 <[email protected]>,
[email protected] 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 <[email protected]>
> 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"
> >> <[email protected]> wrote:
> >>
> >>
> >>>Andy Pope has an add in here.
> >>>
> >>>http://www.andypope.info/charts/polarplot.htm
> >>>
> >>>"Ralph2" <[email protected]> wrote in message
> >>>news:[email protected]...
> >>>
> >>>>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
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>

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

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
>
>

Hi,

Used google to locate your original post.
http://groups.google.com/group/micro...b301ca570a7f29


Cheers
Andy

Taryn wrote:
> 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
>>
>>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info