Radar chart

[drv21]

Hello,

I made a radar chart with some number and it get's the data correctly, however my question is not about data and is about coloring the chart.

Next picture is my chart : chart1.png however i would like to color the chart as in the next picture attached : chart2.png

Is there a possibility of doing this as i couldn't find ? Or is not possible with radar chart ? If not, is there a different way of chart for exact same thing ?

Attaching also the chart file. LMK if the file is not opening.

Thanks!

[Andy Pope]

You can create it using combination of radar and donut.

The donut needs the start angle changing it order to position first slot at the 12 o'clock position.

I used so code to fill the colours.
Select the chart and use the immediate window to execute this 3 lines

Please Login or Register  to view this content.

If you really wanted to you could also change the rotation of each data label.

[drv21]

You can create it using combination of radar and donut.

The donut needs the start angle changing it order to position first slot at the 12 o'clock position.

I used so code to fill the colours.
Select the chart and use the immediate window to execute this 3 lines

Please Login or Register  to view this content.

If you really wanted to you could also change the rotation of each data label.

That's awesome Andy, exactly what i needed. Never thought that i can combine two charts.

Thanks once again !

LE.: i don't understand exactly how did you colored each portion of the donut with that code. Of what window are you talking about when pressing the chart in order to execute the code ?

[Andy Pope]

Select the chart

ALT+F11 to open VBE
CTRL+G to open Immediate window

Paste a line of code into the immediate window and press Enter on the line to execute it.

You should be able to see from the colour name used which of the data points are being coloured.