center the color gradient

The fill goes from the center of the polygon rather than the center of the chart.

Best you could do is use multiple series to create hexagonal bands of colour

You shall use several series and function MIN(real_value,radius_for_given_series) + format with appropriate colors (better/smoother, especially greens and blues, than I used )

Thanks a lot for your input!

I have one more question: The idea is that I enter numbers between 1 and 6 into the green part of the table.
The Spider chart should then change the value (numbers between 1 and 6) of the categories (A to P) to the given value from the green chart.
So, every time I change the values of the categories A to P in the green table the spider chart should adjust the values and keep the given background colour.
The other parts should become transparent.

So thats how it should look in the end (I photoshoped it, unfortunally I couldn't find out how to do it with excel).

The first picture shows how it should look like, the second picture shows how it is right know. The spider graph should be able to adjust the graph if the values of the green table are changing.

Attachment 542405


I also attached my excel file.


Thanks a lot for your help!!

The banding has to be applied to the whole of the radar. You will not be able to get the appearance you want as the angle of change between points will mean the fill either goes outside or just inside the bounding line.

C3 and copy right/down:

Formula:

Please Login or Register  to view this content.

See attached.

PS. You selected nice colors!