Excel radar chart - change axis limit values

Question

with data as below

+---------+-------+-------+-------+
|         | test1 | test2 | test3 |
+---------+-------+-------+-------+
| metricA | -87.1 | -87.3 | -87.6 |
| metricB | 12.35 |  12.2 | 12.25 |
| metricC |   2.2 |   2.1 |  2.05 |
| metricD |   7.7 |   7.9 |   7.8 |
| metricE |  3.61 |  3.36 |  3.48 |
+---------+-------+-------+-------+

I am trying to create a radar chart in excel - I get the following chart - however, since the values ​​are very close, the results of the three tests overlap. How to adjust axis limits so that differences are displayed on the chart? I was able to change it only for one axis - one that corresponds to the metric A.

Answer 1

To compare three tests without participating in the axis scale, you can try some standardization - I got the result OK with subtracting the difference between the test score and the average average number of points for this indicator, for example. =B2-AVERAGE($B2:$D2)

, B2:D7 :

             test1  test2    test3 
 metricA    -87.1   -87.3   -87.6
 metricB     12.35   12.2    12.25
 metricC     2.2      2.1    2.05
 metricD     7.7      7.9     7.8
 metricE     3.61    3.36    3.48

, :

              test1   test2   test3 
 metricA     0.2333  0.0333 -0.2667
 metricB     0.0833 -0.0667 -0.0167
 metricC     0.0833 -0.0167 -0.0667
 metricD    -0.1000  0.1000  0.0000
 metricE     0.1267 -0.1233 -0.0033

:

, :

• =(B2-MIN($B2:$D2))/(MAX($B2:$D2)-MIN($B2:$D2)), , 0 1

• =STANDARDIZE(B2,AVERAGE($B2:$D2),STDEV.P($B2:$D2)), Excel STANDARDIZE.

Answer 2

, , .

first - , : .

A) ( ).

B). , , -85, test1 102% - , , , .

C) (, test1 2,5 )

second - .

- - , . ( ) .

Answer 3

. , , , , .

. . , , . A, .

:

(360 5 ):

• metricA: 0
• metricB: =2*PI()/5
• metricC: =2*2*PI()/5
• metricD: =3*2*PI()/5
• metricE: =4*2*PI()/5

:

x1: ( x )

F2: =SIN($B2)*(E2-$C2)/($D2-$C2)

y1: ( y )

G2: =COS($B2)*(E2-$C2)/($D2-$C2)

x y , .

, : A7: =A2

:

• x y -1 1
• .
• , , .

, . 10% , 10% . , , . .

: =MIN(E2,H2,K2)-(MAX(E2,H2,K2)-MIN(E2,H2,K2))/10

: =MAX(E2,H2,K2)+(MAX(E2,H2,K2)-MIN(E2,H2,K2))/10

, , . .

Answer 4

, ?

, , , , .

Answer 5

None.

Answer 6

, . , :

• 1- 2
• 2 - 3
• 1 - 3

I do not know if this is what you are looking for, but it clearly shows the differences between the values ​​between the tests. Hope this helps!