Polar chart... how

R

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
 
A

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
 
T

Tushar Mehta

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
 
R

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
 
J

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/
_______
 
T

Tushar Mehta

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
 
R

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
 
T

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top