2003 Excel Radar Chart Data Label Position

[Bill]

How do you position a data label on top of the data point in a radar chart?
In an XY scatter plot you can select this from within the Format Data Labels
window and then select Label Position: Center. In a Radar chart you are not
given this option. Why? How could you work around it using a Visual Basic
Macro?

 

[Andy Pope]

Hi,

The reason for no fixed default values is the position of each data label is
relative to the angle of the radar spoke.

With this free addin you can move all or individual data labels.
http://www.appspro.com/Utilities/ChartLabeler.htm

Another option is to plot a xy-scatter chart on the same chart. Adjust the
scales +/- min/max to match radar scale.
The plot points at the correct angle and distance, based on your data. You
can now display data labels using the xy-scatter.
Again you may find the addin useful for linking the data labels to text you
want to display in the data label.

Cheers
Andy