polar plots (add-in)

**dharshanie** · 05-31-2006, 12:08 PM

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?

these are the data points . . .
X (degrees)
-75.96375653
-71.56505118
-63.43494882
-45
0
45
63.43494882
71.56505118
75.96375653

Y (r)

0.008658
0.02635
0.04974
0.06225
0.06532
0.07116
0.07246
0.03745
0.01476

Thanks

Andy Pope · 06-01-2006, 03:50 AM

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/freea...structions.htm
http://www.dslimited.biz/excel_tutor...alladd-in.html

Cheers
Andy

dharshanie wrote:
> 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, Microsoft MVP - Excel
http://www.andypope.info

**dharshanie** · 06-01-2006, 04:45 AM

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 cell of output range"? I have angle data, distance data but didn't get this last option.

What do you mean by that?

Thanks

Andy Pope · 06-01-2006, 04:55 AM

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 wrote:
> 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 cell
> of output range"? I have angle data, distance data but didn't get this
> last option.
>
> What do you mean by that?
>
> Thanks
>
>

--

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

**dharshanie** · 06-01-2006, 06:23 AM

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 · 06-01-2006, 08:00 AM

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

dharshanie wrote:
> 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, Microsoft MVP - Excel
http://www.andypope.info