polar plots (add-in)

[dharshanie]

I've searche dthis forum and found the following link
(http://www.andypope.info/charts/polarplot.htm) which provides an
addd-in for polar plots. My question is . . . how does one install
this add-in? I downloaded it and opened the doc but don't seem to see a
different option even after enabling macros. Can someone help me pls?

Thanks

 

[Andy Pope]

Hi,

Open excel and via the menus Tools > Add-ins...
browse for the .xla file

Once on the list of addins and ticked a new menu will be added to the
Tools menu that displays the polar plot dialog.

Here are a couple of sites with a little more detail on installing addins.
http://www.excel-it.com/addins/freeadd-ins/instructions.htm
http://www.dslimited.biz/excel_tutorials/installadd-in.html

Cheers
Andy

 

[dharshanie]

Hi Andy,

Thanks for that. Managed to install it and find it.

Now I have a problem with using it. What do you mean by "top left cel
of output range"? I have angle data, distance data but didn't get thi
last option.

What do you mean by that?

Thank

 

[Andy Pope]

The top left cell is for generated output that will be charted in order
to create the plot.
Normally an cell to the right of your data with enough empty space for
10 to 20 columns, depending on the options you choose.

 

[dharshanie]

thanks for that Andy. I have managed to get my plot but was wondering if
there is anyway I can close in on the plot? cos all my data points seem
to be very close to the center and hence i cannot differentiate any of
them. Could I adjust the x and y scale like in othe graphs?

 

[Andy Pope]

You can change the min and max values of the x and y axis, just like a
normal chart.