AJP Excel Information

Polar Plot 2 add-in.

The add-in will helps you to create a polar plot from your angle and distance data.

I have written a version for xl2007 as well as for xl2003 and previous version. This add-in addresses some of the missing features in my previous add-in. Due to the different approach taken with this latest version it is not backward compatible with charts created using the previous add-in.

XL2007

Download latest version of Polar Plot2 [] (156KB)

For instructions on how to install add-in. 

Once installed the add-in creates 2 new buttons on the ribbon. The first is the Create button added to the Insert tab.

Use the Create button to initiate the Create dialog. If you select your data range in advance the add-in will attempt to use your data layout to preload the data parameters.

The Data tab allows you to select the data range. The data layout should be angles in first column with adjacent columns containing distance data for each series you which to include in the plot. By default the calculated chart data will be stored to the right of your data with a single column space between. This new data is a store of the chart options as well as information use to create the charts labelling, axes and then actual series lines.

Once you have created your polar chart you can edit it using the Update button added to the Layout tab of the Chart Tools contextual tab.

The Update button invokes the add-in with the Options tab populated and displayed.

The example preview gives you a view of the changes made. Moving the mouse over a control will display explanation text. You can also update the Data settings.

Here are some examples.

Default chart	Multiple series	Negative data values

Gaps in the data	Clockwise direction	Different Interval labels

Data markers only and no interval labels	Offset Interval start	Value axis in reverse order

Gap data with line manually formatted to have Arrow endings.

Once the chart has been created you can format the interval labels, interval lines, circular gridlines, values axis and each series using the standard chart formatting methods.

Download example file [] (47KB)

XL2003

Download latest version of Polar Plot2 [] (136KB)

Once installed the add-in creates 2 new buttons within the menus. The first is the Create button added to the Insert menu.

Use the Insert button to initiate the Create dialog. If you select your data range in advance the add-in will attempt to use your data layout to preload the data parameters.

The Data tab allows you to select the data range. The data layout should be angles in first column with adjacent columns containing distance data for each series you which to include in the plot. By default the calculated chart data will be stored to the right of your data with a single column space between. This new data is a store of the chart options as well as information use to create the charts labelling, axes and then actual series lines.

Once you have created your polar chart you can edit it using the Update button added to the Chart menu.

The Update button invokes the add-in with the Options tab populated and displayed.

The example preview gives you a view of the changes made. Moving the mouse over a control will display explanation text. You can also update the Data settings.

Here are some examples.

Default chart	Multiple Series	Negative data values

Gaps in data	Different Interval labels	Data markers only and no interval labels

Clockwise direction	Offset interval start	Value axis in reverse order

Once the chart has been created you can format the interval labels, interval lines, circular gridlines, values axis and each series using the standard chart formatting methods.

Download example file [] (302KB)

• v2.3 Amended formula to handle scaling which does not pass thru zero.
  

• v2.2 Amended formula to handle negative values when user alters the minimum scale value.
         Added a Save Settings option that will store current dialog settings in the registry for use when creating future polar plots.

• v2.0 release version

Alternative links

Stephen Bullen - FunChrt6 Polar plots

Bernard V Liengme - Polar plots

Polar Plot add-in

Polar Plot using radar chart