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" wrote in message
...
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"
wrote:

Andy Pope has an add in here.

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

"Ralph2" wrote in message
.. .
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"
wrote:


Andy Pope has an add in here.

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

"Ralph2" wrote in message
. ..

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 ,
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 ,
says...
On Tue, 1 Nov 2005 05:12:20 -0500, "Barb Reinhardt"
wrote:

Andy Pope has an add in here.

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

"Ralph2" wrote in message
.. .
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
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"
wrote:


Andy Pope has an add in here.

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

"Ralph2" wrote in message
...

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 ,
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 ,
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
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"
wrote:


Andy Pope has an add in here.

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

"Ralph2" wrote in message
...

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 ,
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
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"
wrote:


Andy Pope has an add in here.

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

"Ralph2" wrote in message
...

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" wrote in message
...
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