Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Default Data Label Position | Charts and Charting in Excel | |||
Various amount of data when making a radar chart | Charts and Charting in Excel | |||
Excel 2003 Line Chart - Switch Axis Position | Charts and Charting in Excel | |||
How to change the category label of a radar graph?? | Excel Discussion (Misc queries) | |||
Excel 2003 radar chart - maximum discrete data points | Charts and Charting in Excel |