2003 Excel Radar Chart Data Label Position

B

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?
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to change the category label of a radar graph?? 3
chart data label as hyperlink 2
Excel 2007 - Moving Data Labels on a Radar Chart 0
dynamic radar chart 1
Radar chart with Area and Lines 1
Pivot Chart Data Label Format Question 3
changing the source range of a chart 3
radar chart & labels 1

Top