Polar Charting

[theant]

Is there a way to do polar charting within excel? I am
familiar with owc11, but prefer to have the functionality
withing excel. Also, I would be needing to maipulate the
chart programatically. Such as setting chart type to
xl3DBar.

Will the next version of excel have it?

Thx in advance,

 

[Andy Pope]

Hi,

You can create the polar chart your self using calculated values and
extra data series.

Check Stephen Bullen's example, FunChrt6.zip.
http://www.bmsltd.ie/Excel/Default.htm

Or I have an addin on my site.
http://www.andypope.info/charts/polarplot.htm

Cheers
Andy