Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Default Data Label Position Kermit Charts and Charting in Excel 2 January 16th 08 01:18 AM
Various amount of data when making a radar chart Anna S Charts and Charting in Excel 9 January 4th 08 09:42 AM
Excel 2003 Line Chart - Switch Axis Position sot Charts and Charting in Excel 2 September 27th 07 01:12 PM
How to change the category label of a radar graph?? Lee Excel Discussion (Misc queries) 3 July 13th 07 06:54 PM
Excel 2003 radar chart - maximum discrete data points Daniel@UDRI Charts and Charting in Excel 5 August 25th 06 02:57 PM


All times are GMT +1. The time now is 10:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"