|
RE: radar chart & labels
Move the axis
labels to the side of the plot area
|
|
|
A |
B |
C |
D |
1 |
Radar |
|
Grid |
|
2 |
2 |
|
-1 |
0 |
3 |
1 |
|
-1 |
0.5 |
4 |
2 |
|
-1 |
1 |
5 |
1 |
|
-1 |
1.5 |
6 |
2 |
|
-1 |
2 |
7 |
1 |
|
-1 |
2.5 |
8 |
2 |
|
-1 |
3 |
9 |
1 |
|
|
|
Create a radar
chart based on the range A2:A9
|
|
Use the Source data dialog to
add an extra data series
|
Change the new data series to
an xy scatter chart and then set the x values to the range C2:C8
and the y values to D2:D8.
Format the secondary y axis
to have a minimum value of -3 and a maximum of +3
Format the secondary x axis to have a minimum value of -1 and a
maximum of -1
|
Format the data points to
none. Apply data labels, displaying the y value.
Change the alignment of the data labels to Left.
The horizontal lines are
positive X error bars using a fixed value of 1.
|
Finally finish off the
formatting of the error bars and the value axis of the radar
chart, removing the grid lines.
|
|
|