Polar chart... how

[Ralph2]

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

[Barb Reinhardt]

Andy Pope has an add in here.

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

"Ralph2" <none...@hotmail.com> wrote in message
news:obtdm1lp2vk077fs0...@4ax.com...

[Ralph2]

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]

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

--

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

[Tushar Mehta]

In article <mr8gm1plnijfbd8vi...@4ax.com>,
none...@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 <mr8gm1plnijfbd8vi...@4ax.com>,
none...@hotmail.com says...

[Ralph2]

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 <an...@andypope.info>
wrote:

[Jon Peltier]

I'm late to the dance, but Stephen Bullen has an annotated example on
his web site:

http://www.oaltd.co.uk/DLCount/DLCount.asp?file=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/
_______

[Tushar Mehta]

In article <3crim1d0i4m5e8uie...@4ax.com>,
none...@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 <3crim1d0i4m5e8uie...@4ax.com>,
none...@hotmail.com says...

[Tushar Mehta]

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 <3crim1d0i4m5e8uie...@4ax.com>,
none...@hotmail.com says...

[Bernard Liengme]

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" <none...@hotmail.com> wrote in message
news:obtdm1lp2vk077fs0...@4ax.com...

[Ralph2]

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

[Taryn]

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?

[Andy Pope]

Hi,

Used google to locate your original post.
http://groups.google.com/group/microsoft.public.excel.charting/browse_thread/thread/6ab301ca570a7f29

Cheers
Andy

--