View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 2003 Excel Radar Chart Data Label Position

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Bill" wrote in message
...
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?